How to create a chart that uses data from another chart
This procedure assumes you have already created the primary chart.
1 Specify a name for the primary chart, using the following steps:
1 In the layout editor, select the chart. In Property Editor, choose the Properties tab.
2 In General properties, in Name, type a name for the chart.
2 Insert a second chart in the report.
3 In the chart builder, select a chart type suitable for displaying the same data as the primary chart, then choose Select Data.
4 Select the data to display in the chart, using the following steps:
1 Under Select Data, select Use Data From, and click the down arrow to display a list of items from which to get data.
2 Under Report Items, select the chart from which to use data.
The chart builder fills in the value and category series fields with the data defined in the primary chart.
5 Choose Finish to save the chart.
6 Preview the report to verify that the chart displays the correct data.