Versions Compared

Version Old Version 12 New Version Current
Changes made by

Former user

Jeroen de Soeten

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Introduction

The Multiple Bar & Line Charts template is the most flexible template when it comes to charts. Reports of this template can display up to 6 charts that can be highly customized. Every chart can have two different data sets that can be scaled and formatted individually.

Read more about specific chart formats in the /wiki/spaces/CXO/pages/2806776298 article.

CONTENT

Table of Contents

Settings

The Report Settings define the look & feel and behavior of a report. Explanation regarding the General Settings, Point of View & Dimensions and Comments Settings can be found in Report Settings.

Every setting displayed in the table below occurs 6 times, so all settings as described configure 1 of the 6 charts.

Content Settings

 

Settings

Description

Mandatory

Chart# Bars List

A Lists that defines the bars part of the chart. Check the Chart Bar Style article for formatting options.

No

Chart# Lines List

A Lists that defines the lines of the chart. Check the Chart Line Style, Chart Dash Style and Chart Shape Style articles for formatting options.

No

Chart# Time Series

A list that defines the items for the X Axis. This list typically exists of time dimensions like year and period, but other dimensions can also be used.

Yes

Labels, Formats and Colors

SettingsDescriptionMandatoryChart# TitleThe Title of the ChartNo

 Chart# Y Axis Title

The title to be displayed vertically next to the y axis

No

 Chart# Right Y Axis Title

The title to be displayed vertically next to the second y axis on the right of the chart

No

 Chart# Axis Labels FormatThis settings allows you to chosse the Labels formatYes Chart# Axis Labels PostfixA symbol that can be included at the end of the Axis LabelNo Chart# Data Label FormatThe format of the data labelYes

Chart# Show Every N label

This setting allows you to show every n parameter. This could help make a chart more legible by showing less labels

Yes

Chart# Labels Intersect Action

This setting determines what action should be taken when Labels intersect: apply multiple rows, rotate or wrap

Yes

Chart# Rotate Labels

This setting allows you to rotate the labels clockwise, counterclockwise, horizontally or vertically

Yes

Other

SettingsDescriptionMandatoryChart# Use Dual Y-AxesSet to Yes if you want a second Y-axis for the Line-chart (in case Bars and Lines are combined in 1 axis frame)YesChart# ZoomThe zoom setting defines if the chart y axis should be zoomed. If you select no the y axis will always start at 0 or lowerYesChart# Legend PositionChoose the position of the chart legend (e.g. Bottom, Right, etc.)NoChart# Legend SizeSpecify the legend size which is the percentage of the chart size. This setting will be ignored if Legend Position is set to Do not showNoChart# OrientationThis parameter allows you to rotate the chart and make the display of the chart either Vertical or HorizontalYes

Common

SettingsDescriptionMandatoryScaleThis defines the scaling used in the report. Options are: Unchanged (no scaling), Thousands, Millions, Billions, Percentage. The last option multiplies the amount by 100 to show for example an amount of 0.75 from the source as '75%' in the CXO-Cockpit. The scale setting is the default for all data in the report, but can be overruled by a specific (non-default) scaling in the Member List.YesPrecisionThis defines the number of decimals used for presenting the number. Options are 0-12. Similar to the Scale setting, the Precision setting is the default for all data in the report, but can be overruled by a specific (not -1) precision in the Member list.YesFrequency

This defines the frequency of the report. Options are M (Monthly), Q (Quarterly) , Y (Yearly) or Any (user select). The frequency setting also impacts the options in the Point of View: Upon selecting M, the user can only select the Months. If you select Q, the user can only select Quarters. Selecting Any (user select) will allow the user to select either a Month, Quarter or Year from the Point Of View as required.

YesPaletteColor Palette allows you to customize colors displayed in a reportYesLeft Footer TextEnter a text that will appear in the lower left part of the report. This is dynamic label where you can use dimension values like [VAL] or one or more of the listed static indicators.Yes

 For more details how to control the settings of the charts see article: Bars & Lines Charts Control

See Also

Functional end-user description of template:Multiple Bars and Lines