2022.1

When creating a data mapping configuration (see "Data mapping workflow" on page246), it is
recommended to arrange data in a detail table in such a way that it matches this 'one series per
record, one bar/point per data field' approach.
Occasionally you may find that data in a detail table does not match this approach, and that it
would be a better fit if the chart had one series of bars/points for each selected detail data field
instead, and one bar/point for each record.
If the number of records in a detail table is consistent throughout all records, it is recommended
to modify the detail table in the data mapping configuration in order to make it match the default
approach.
Otherwise this requires changing the Chart script: open the Chart script, click the Expand
button, and alter the code that puts data in the dataProvider property.
Note
How to create a Pie Chart that has one slice per detail record is explained in a How-to:
Put one slice per detail record in a Pie Chart.
In Connect versions up to 1.8, transposing data was possible via the Rows are series option in
the Chart script wizard. As of version 2018.1, this option is no longer available.
For a list of backward compatibility issues concerning charts, please see: "Business Graphics:
Backward Compatibility Issues introduced in 2018.1" on page116.
Enhancing a charts' design
Charts inserted with a wizard always have the same layout. The amCharts library that is
integrated in Connect has loads of options to layout charts differently. Here's how to make use
of those options.
Start by opening the Chart Properties dialog. Right-click the chart (in the template, or in the
Outline pane) and select Chart.
Every tab menu in the Chart Properties dialog, except the last one, gives direct access to a
number of layout options. For a description of the options see:
l "Bar Chart Properties dialog" on page1004
l "Line Chart Properties dialog" on page1034
l "Pie Chart Properties dialog" on page1050
Page 740