{"id":26996,"date":"2017-05-11T12:56:10","date_gmt":"2017-05-11T04:56:10","guid":{"rendered":"http:\/\/localhost\/help\/?page_id=26996"},"modified":"2018-01-16T10:26:28","modified_gmt":"2018-01-16T02:26:28","slug":"faq-configuring-charts-4-4-6","status":"publish","type":"page","link":"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-resources\/faq-configuring-charts\/faq-configuring-charts-4-4-6\/","title":{"rendered":"FAQ – Configuring Charts (4.4.6)"},"content":{"rendered":"

<\/p>\n

This article applies to versions 4.4.6 and earlier of P2 Explorer. For the latest, see FAQ - Configuring Charts<\/a>.<\/p>\n

How do I update a variable from a chart?<\/h2>\n

It is possible to configure a chart such that when a user clicks on an area of the chart, this updates a variable on the page with the selected X Axis value (the variable is then used by other page components, such as a text label, or a parameter to a dataset query, or a variable for a hyperlink).<\/p>\n

To configure the chart to update a variable, follow the steps below.<\/p>\n

Step 1: Add a text variable to the page defaults, and give it a value. See<\/em> Default Values<\/a>.<\/p>\n

Step 2: Click the chart to configure it. Now click the X Axis<\/strong> on the chart's properties to expand the X Axis properties, and select the new variable name from the Selected<\/strong> drop-down list. See<\/em> Charts<\/a>.<\/p>\n

<\/a><\/p>\n

Note:<\/strong> Ensure that the chart is a discrete chart<\/em>, i.e. the X Axis<\/em> Data Type<\/strong> must be String<\/em>.<\/p>\n

<\/a><\/p>\n

Read more: Variables<\/a><\/p>\n

\u00a0<\/p>\n

\n

How do I add a label?<\/h2>\n

First click on the chart to configure it.<\/p>\n

To add an X Axis label: click X Axis<\/strong> on the chart's properties to expand the X Axis properties. For the Label<\/strong>, either keep Text<\/em> and type a label in the edit box, or select Variable<\/em> and then select a variable from the drop-down list.<\/p>\n

<\/a><\/p>\n

To add a Left Y Axis label: click Left Y Axis<\/strong> on the chart's properties to expand the Left Y Axis properties. For the Label<\/strong>, either keep Text<\/em> and type a label in the edit box, or select Variable<\/em> and then select a variable from the drop-down list.<\/p>\n

To add a Right Y Axis label: click Right Y Axis<\/strong> on the chart's properties to expand the Right Y Axis properties. For the Label<\/strong>, either keep Text<\/em> and type a label in the edit box, or select Variable<\/em> and then select a variable from the drop-down list.<\/p>\n

Tip:<\/strong> The label should match the data from the column used for that axis. For example, if your X Axis uses States<\/em>, display States<\/em> in the label, and if your series plotted against the Left Y Axis are showing a dollar value, the label should reflect this.<\/p>\n

<\/a><\/p>\n

Read more: Charts<\/a><\/p>\n

\u00a0<\/p>\n

\n

How do I add a legend?<\/h2>\n

Chart legends have a key that matches to the series by colour and series type (for example, a blue bar matching the blue bar series). You need to assign a Name<\/strong> to each of the chart's series, and then select the chart's Legend<\/strong> option.<\/p>\n

Step 1: First click on the chart to configure it.<\/p>\n

Step 2: Click a series to open it (for example, click Bar Series<\/strong>). Type a name in the Name<\/strong> edit box (or select a Variable<\/strong> from the variable drop-down list). The name should match the series' Y Column (for example, if the Y Column uses actual costs, you could type 'Actual' in the Name<\/strong> edit box).<\/p>\n

<\/a><\/p>\n

Step 3: Do the same for any other series in the chart.<\/p>\n

Step 4: Under Other<\/strong>, select the Legend<\/strong> check box. Optionally select a different Legend Position<\/strong>.<\/p>\n

<\/a><\/p>\n

<\/a><\/p>\n

Read more: Charts<\/a><\/p>\n

\u00a0<\/p>\n

\n

How do I change a series?<\/h2>\n

You can change an existing series in a chart. For example, change a bar series to a line series. Follow the steps below:<\/p>\n

Step 1: First click on the chart to configure it.<\/p>\n

Step 2: Click a series to open it (for example, click Bar Series<\/strong>). Select a different series type from the Type<\/strong> drop-down list.<\/p>\n

<\/a><\/p>\n

<\/a><\/p>\n

Note:<\/strong> If your chart is showing Continuous Data<\/em> (i.e. your X Axis has a Data Type<\/strong> of Number<\/em> or Time)<\/em>, you cannot change your series type to Bar<\/em> or Stacked Bar<\/em>. These are only available for charts showing Discrete Data<\/em>).<\/p>\n

Read more: Charts<\/a><\/p>\n

\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"

This page answers frequently asked questions about configuring charts in Explorer Studio, for P2 Explorer 4.4.6 and earlier.<\/p>\n

Read more<\/i><\/a><\/p>\n","protected":false},"author":1,"featured_media":19276,"parent":24327,"menu_order":3,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":"","_members_access_role":[],"_members_access_error":""},"categories":[4],"tags":[15,485],"class_list":["post-26996","page","type-page","status-publish","has-post-thumbnail","hentry","category-explainer","tag-charts-2","tag-faq","Product-ex"],"_links":{"self":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/26996","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/comments?post=26996"}],"version-history":[{"count":0,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/26996\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/24327"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/media\/19276"}],"wp:attachment":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/media?parent=26996"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/categories?post=26996"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/tags?post=26996"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}