When multiple identical group labels exist in a dataset, this macro will reorganize the matching group labels into "virtual" groups and create a new series for each of the identical groups. The original data is read into the chart as one or more series (Series 0 ... Series n) and many different group labels. With @DATASET_MERGE, the data is reorganized with a new series labels when group labels change.
SYNTAX:
@DATASET_MERGE bAppendSeriesLabelPARAMETERS:
bAppendSeriesLabel; 1 = Appendix Series Label (e.g., Series1:Group1), 0 = Do not append Series Label (e.g., Group 1, Group 2, etc.).
EXAMPLE:
The data set consists of 1 series and 9 groups:
Group1
Group1
Group1
Group2
Group2
Group2
Group3
Group3
Group3
Series1
1
8
7
4
5
2
7
8
1
@DATASET_MERGE 1After @DATASET_MERGE is applied, the data used to draw the chart is reorganized as shown in the following table.
Series1:Group1
Series1:Group2
Series1:Group2
1
4
7
8
5
8
7
2
1
