Creating Sub-Charts

You can define a set of rules that are used to break your chart into sub-charts.

To create sub-charts:

1        With the chart open, click the Insert tab and select Create from the Sub-Chart section to display the Create Sub-charts dialog box.

2        Define your sub-charting options as follows:

·         Create Sub-charts: Select one of the following criteria according to which sub-chart breaks should be created.

·       Every: Creates a sub-chart break at every nth level in the chart.

·       Using Field: Creates a sub-chart at each occurrence of the field.

·       At Level: Creates a sub-chart break at the specified levels. (Separate level numbers by comma.)

·       Condition: Defines a condition based on complex criteria. The Condition dialog is displayed.

·         Smart Sub-chart breaks: Specify the minimum number of boxes in a branch before a break is inserted.  

·       Name Sub-charts: Specify how each sub-chart page should be named. Select from:

·       From Field: All sub-charts are based on the value of the specified field. The field value is extracted from a box when a sub-chart break is inserted.

·       Apply to: Specify whether the sub-chart rules are to be applied to the Entire Chart, the Active sub-chart, or the current Selection.

3        Click OK. The chart is sub-charted according to the selected options