{"id":2210,"date":"2015-03-11T22:13:41","date_gmt":"2015-03-11T14:13:41","guid":{"rendered":"http:\/\/localhost\/help\/?page_id=2210"},"modified":"2016-10-13T11:54:45","modified_gmt":"2016-10-13T03:54:45","slug":"line-chart-4-3-2","status":"publish","type":"page","link":"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-studio\/controls\/charts\/charts-4-3-2\/line-chart-4-3-2\/","title":{"rendered":"Line Chart (4.3.2)"},"content":{"rendered":"

<\/p>\n

This article applies to versions 4.3.2 and earlier of P2 Explorer. For help on the latest version of the chart, see Charts<\/a>.<\/p>\n

Overview<\/h3>\n

The line chart is a series of value points connected by lines. The following diagram shows a line chart in design mode:<\/p>\n

(See separate topics for: Bar Chart<\/a>, Stacked Bar Chart<\/a>, Area Chart<\/a> and Dot Chart<\/a>.)<\/p>\n

\u00a0<\/div>\n
\"addingalinechart1\"<\/a><\/div>\n
\n

The chart has three mandatory selections (marked with an asterisk *) that have not been preconfigured: Source Data<\/strong>, at least one Series<\/strong> (define the Y Column<\/strong>), and the X Axis<\/strong> (define the Column<\/strong>). You\u2019ll need to fill these in yourself.<\/p>\n

\"addingalinechart3\"<\/a><\/div>\n<\/div>\n
\u00a0<\/div>\n
\u00a0<\/div>\n
\n\n\n\n\n\n\n
Source Data:<\/strong><\/td>\nThis is a mandatory selection. Your chart data comes from this source data.<\/td>\n<\/tr>\n
Series:<\/strong><\/td>\nYour chart needs at least one series. Click Add<\/strong> for new series, or Remove<\/strong> to remove a series.<\/td>\n<\/tr>\n
 <\/td>\nThe chart definitions here cover the elements of a Line Series<\/em>. Other types are Bar Series<\/em>, Stacked Bar Series<\/em>, Area Series<\/em> and Dot Series<\/em>.<\/td>\n<\/tr>\n
 <\/td>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Type:<\/em><\/strong><\/td>\nEach series can be plotted to best suit your data. The default is Line Series<\/em>.<\/td>\n<\/tr>\n
Y Column:<\/em><\/strong><\/td>\nThis is a mandatory selection. Select a value from the source data, or hook this up to an event. The Y Column<\/strong> values get plotted against the Y Axis<\/strong>.<\/td>\n<\/tr>\n
Name:<\/em><\/strong><\/td>\nGive the Y Column<\/strong> a name. This appears in the legend, and should describe what is being represented. For example, the name COSTS<\/em> can be applied to a series where the Y Column<\/strong> is the value TOTAL_AMT<\/em>, if this value represents costs.<\/td>\n<\/tr>\n
Name Column:<\/em><\/strong><\/td>\nAs an alternative to Name<\/strong>, you may prefer to have a variable label in the legend. Select a value from the source data, or use an event, to show the label. This value overrides the value entered into Name<\/strong>, and effectively splits the bar into separate, smaller groups (bars). For example, use the value COST_TYPE<\/em> (a column from the source data) as aName Column<\/strong> for Y Column<\/strong> TOTAL_AMT<\/em>. Here, the TOTAL_AMT<\/em> per COST_TYPE<\/em> is shown as a separate line.<\/strong>.<\/td>\n<\/tr>\n
Y Axis:<\/em><\/strong><\/td>\nChoose left or right for the Y Axis<\/strong>. If you have more than one series, with a very different range of values, then you might choose to have a Left Y Axis<\/strong> for one series, and a Right Y Axis<\/strong> for others, so that values line up better on a single chart.<\/td>\n<\/tr>\n
Filter Column and Filter Value:<\/em><\/strong><\/td>\nUse Filter Column<\/strong> and Filter Value<\/strong> together, instead of the Name Column<\/strong>, if the Y Column<\/strong> values come from a field that stores values apart from the ones you want for this series. With Filter Column<\/strong> and Filter Value <\/strong>you will also need to specify a Name<\/strong>. (More)<\/a><\/td>\n<\/tr>\n
Colour:<\/em><\/strong><\/td>\nSpecify the colour of the series in hexadecimal, for example #913D88<\/em> or RGB format, for example RGB(145,61,136)<\/em>. You can also just type in the name of a colour, for example RED, BLUE, MAGENTA, YELLOW<\/em> etc.<\/td>\n<\/tr>\n
Colour Matcher:<\/em><\/strong><\/td>\nYou can type in a reserved word to get the correct matching colour. For example, OIL<\/em> gives you the correct values for the specific oil green. Note that Colour<\/strong> overrides Colour Matcher<\/strong>, so keep it empty if you want to use Colour Matcher<\/strong>. Colour matcher values you can use are OIL, GAS, NGL<\/em> and WATER<\/em>. This is particularly useful if you\u2019re driving the colour from a value in the source data, and want it to be meaningful for the value that it\u2019s representing.<\/td>\n<\/tr>\n
Interpolation:<\/em><\/strong><\/td>\nYour choice here determines how the points on the chart are connected. The default value is Monotone<\/em>. Other choices include Step<\/em> and Linear<\/em>. The full list is in the drop-down.<\/td>\n<\/tr>\n
Thickness:<\/em><\/strong><\/td>\nDetermines the line thickness.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n
Axes:<\/strong><\/td>\nEach chart has an X Axis<\/strong> and either one or two Y Axes<\/strong>.<\/td>\n<\/tr>\n
 <\/td>\n\n\n\n\n\n
X Axis:<\/em><\/strong><\/td>\nThe X Axis<\/strong> is the principle axis, horizontal by default, containing the values against which other values are then measured (for example, AREAS<\/em> (X Axis<\/strong>) with allocated BUDGETS<\/em> (Y Axis)<\/strong>.<\/td>\n<\/tr>\n
 <\/td>\n\n\n\n\n\n\n\n\n\n\n\n
Column:<\/strong><\/td>\nChoose a column from your source data for example, AREA<\/em>. The column values for the result rows are then plotted along the X Axis<\/strong> (for example, Fayetteville, Haynesville, Area ABC, etc.). (Be careful to pick a column that has no duplicates.)<\/td>\n<\/tr>\n
Data Type:<\/strong><\/td>\nThis defaults to String<\/em>, and should be compatible with the Column<\/strong>. If Column<\/strong> can be represented as a number, then you can select Number<\/em> from the drop-down (the third option is Time<\/em>). If this is still not compatible with some of the series, then you will get a warning message.<\/td>\n<\/tr>\n
Visible:<\/strong><\/td>\nIf this is not selected (select the check box or let an event determine this), the X Axis<\/strong>values do not appear along the X Axis<\/strong>.<\/td>\n<\/tr>\n
Values:<\/strong><\/td>\nAdd one or more values to the existing values on the X Axis<\/strong> that are returned from the source data.<\/td>\n<\/tr>\n
Label:<\/strong><\/td>\nThis can be blank, or add a label (value or event) to be displayed below the X Axis<\/strong>.<\/td>\n<\/tr>\n
Selected:<\/strong><\/td>\nName an event here if you want to use the selected X Value in labels or as a parameter to other dataset queries. At run-time, click a band on the X Axis to select it.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n
Left Y Axis:<\/em><\/strong><\/td>\nThe Left Y Axis<\/strong>, vertical by default, is used for plotting values of the X Axis<\/strong>. Note that this axis is only used if Left is selected as the Y Axis<\/strong> in one or more series (it is, by default). The Left Y Axis<\/strong> comes preconfigured.<\/td>\n<\/tr>\n
 <\/td>\nTicks:<\/strong>Defines the number of Y Axis intervals<\/p>\n\n\n\n\n\n\n\n\n\n\n
Min and Max:<\/strong><\/td>\nThe max value cannot be exceeded, so only set Max <\/strong>if you know what the max should be, or if you are only interested in showing up to a maximum value. The same applies to Min<\/strong>. Min\/Max can be left out (no limit set), or assigned a numerical value (the limit), or assigned an event (a variable limit). For example, you might use source data that returns the max value of the Y Field<\/strong>: that would be a good variable (event) maximum to use.<\/td>\n<\/tr>\n
Visible:<\/strong><\/td>\nIf this is not selected (select the check box or let an event determine this), the X Axis<\/strong>values do not appear along the X Axis<\/strong>.<\/td>\n<\/tr>\n
Label:<\/strong><\/td>\nThis can be blank, or add a label (value or event) to be displayed alongside the Y Axis<\/strong>.<\/td>\n<\/tr>\n
Enable Gridlines:<\/strong><\/td>\nEnable or disable gridlines.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n
Tick Format:<\/strong><\/td>\nFormat the Y Field<\/strong>, which is displayed along the Y Axis<\/strong>. For example, if your Y Field<\/strong> is a dollar value, you can type in the dollar $<\/strong> symbol. Your labels would then look like $ 50.00, $ 25.00 and so on. Other formatting to use are the signs (+\/-), the comma (for a thousands separator),<\/strong> and precision symbols. You can use these together, for example \u201c$ ,\u201d displays the currency symbol and has a thousands separator.<\/td>\n<\/tr>\n
Scale Type:<\/strong><\/td>\nThe default option is Linear<\/em> (showing the actual values). Logarithmic scale (Log<\/em>) displays a logarithmic calculation, which is useful when you have a wide range of values to display. Tip<\/strong>: If using Log<\/em>, show this in your label. If you set this as an event, then the user can toggle between the log and linear scale quite easily, with the help of a combo box.<\/td>\n<\/tr>\n
Log Gridlines:<\/strong><\/td>\nNote: This only applies to the Log<\/em> Scale Type<\/strong>. Options are: Major Only<\/em>, and Major and Minor<\/em>.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n
Right Y Axis:<\/em><\/strong><\/td>\nThis is the same as the Left Y Axis, and can be used instead of or together with the Left Y Axis. It is useful to have these two separate axes if there are series with very different expected values; this way, all series can be better scaled to show up well in the chart. Another use of having both Y Axes would be to show different types of measures. For example, show dollars along the Left Y Axis, and counts along the right Y Axis.
\n Note that this axis is only used if Right<\/strong> is selected as the Y Axis in one or more series.
\n The Right Y Axis is pre-configured. This axis has the same components as the Left Y Axis.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Other:\u00a0<\/strong>This is where you can configure the general chart appearance, such as orientation.<\/p>\n\n\n\n\n\n\n
Orientation:<\/em><\/strong><\/td>\nCharts default to vertical. If you change this to horizontal, then your Y Axis is plotted along the horizontal, and your primary values (X Axis<\/strong>) move to the vertical. Horizontal is useful if you are expecting a lot of X Values, as the legends stack neatly underneath each other (horizontally).<\/td>\n<\/tr>\n
Legend:<\/em><\/strong><\/td>\nThe legend displays the values of the X Axis Field<\/strong>.<\/td>\n<\/tr>\n
Legend Position:<\/em><\/strong><\/td>\nThis option only appears if you select the Legend<\/strong>. Right by default. This can be Left<\/em>, Right<\/em>, Top<\/em>, or choose Top-inside<\/em> if you have limited space.<\/td>\n<\/tr>\n
Tooltip:<\/em><\/strong><\/td>\nTooltips show the Y value when you hover your mouse over that area of the chart (e.g. over a bar).<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
\u00a0<\/div>\n
\u00a0<\/div>\n
\n
\n
\n

Tutorial<\/h3>\n<\/div>\n
\n

You can put a chart together in a matter of minutes, as most of the chart options are preconfigured.<\/p>\n<\/div>\n

\n
\"budgetlinechart\"<\/div>\n<\/div>\n
\n

Follow the step-by-step instructions for adding this chart.<\/p>\n

\n

Step by Step: Adding a Line Chart<\/h3>\n

Before you start, open a new tab in Explorer and add a new page in grid<\/a>\u00a0layout.<\/p>\n

If you have access to the training environment, you can follow the steps exactly as outlined here. Otherwise, you will need to adjust the configuration to suit your data.<\/p>\n

Step 1. Add and configure Source Data<\/strong><\/p>\n<\/div>\n<\/div>\n

\"configuredatasource3\"<\/p>\n

Click Add Data<\/strong>, then select the Dataset<\/strong> option. Select the Training<\/em> Datasource, then click LandCostsBudgetVersusSpent<\/em> and Add<\/strong>. Configure as follows:<\/p>\n