Chart Settings

Show TOC

You can set chart options to change the look of the chart.

Prerequisites

The Graph Items dialog box is displayed.

Features

You can set the following chart settings:

Change the chart type by clicking an icon that represents the type.

Note
If you are selecting more than two series, you cannot select Bar & Line. If you are selecting more than three series, you cannot select 2 Bars & 1 Line or 1 Line & 2 Bars or 2 Stacked & Line. When creating a pie chart, you can only select one series.

End of the note.
Select items to graph. The series are charted in the order they appear in the Selected items list. You can change the order that items appear using Move Up and Move Down.
Remove items from the chart.
If the dimension or metric names are so long that you cannot see the full name, you can resize the dialog box.
It is possible to have dimension member labels as long as 128 characters. If you have long member names, they may not appear in the chart. If you are changing the chart settings of a report in the Reports component, you can select a smaller number in the Display label characters drop-down list of the Presentation section to display a portion of the labels.
If you are creating a chart that compares trends between disparate items, you can chart two or three series on the same chart, using dual Y-axis scales and different chart types to differentiate the series for each axis. A dual axis allows you to more accurately represent the comparison of disparate items.
Select the periodicity for the chart. The time periods appear along the X-axis. By default, all periods for which there is data are charted according to the selected periodicity.

You can set the following chart options:

When creating a pie chart, some of the options in the Options tab of the Graph Items dialog box appear to be selectable when they have no effect on the pie chart and should be grayed out. The Horizontal Grid Lines, Vertical Grid Lines, Y Axis Minimum, Maximum, and Label options are ignored. The Title, Scale, Display Legend, and Color Series options work as expected.
Type a title for the chart.
Specify minimum and maximum values to chart along the Y-axis. By default, all values are displayed.
The chart will be adjusted to show all points starting at the minimum number. If any points are lower than that number, they are shown starting from the minimum number. The chart will be adjusted to show all points up to the maximum number. If any points exceed that number, they are cut off at that number.
Add a label that will appear along the Y-axis of the chart.
Add horizontal and/or vertical grid lines.
Display the chart legend.
Scale the numbers. For example, if you have numbers in the millions, you might want to scale it by 1,000,000 to show all numbers as single digits. Then you can identify the scale being used in the label.
Change the color of a series. The current designations are show in the Colors list.

Activities

To change the chart settings in the Reports component, click Graph items in the Graph section of the Settings panel.
To change the chart settings in a KPI Details screen of the Scorecard component, click Graph Options.
To select items to graph, select items from the Select items to graph section and click Add to graph.
To use a dual Y-axis to chart disparate items, select either Bar & Line, 2 Bars & 1 Line, 1 Bar & 2 Lines, or 2 Stacked & Line as the graph type. Then you can select Dual Y Axis.
To select the periodicity for the chart, select a period from the Select dates drop-down list. Then select whether you want to chart all the data, or just the last x periods.
To change the color of a series, select the series and then select the color from the Change Colors drop-down list.