Charting

Creating multiple charts with varying numbers of lines can be time consuming, because each Series must be selected to include the desired lines in the chart. By modifying the XML code, you can automatically select the desired number of lines to include. Imagine the time savings of creating 50 state charts, and doing this by hand, verses automatically by modifying the XML code.

The module processing steps

Run Charting_10_10_11.yxmd

Data is transposed and cross-tabbed:

Regions are grouped and counted to determine the number of lines to put in the chart:

XML - One thing to keep in mind is that not all of the XML in a tool needs to be updated to work correctly. There are usually short cuts! For example in the charting tool, the series are referenced in the XML in 2 places - once for the color configuration and once for the data attributes. You only need to update the XML for the series details, the colors do not need an update as they will dynamically be applied saving a larger update and configuration to the tool.

Portions of the XML code are created:

XML code is combined into one table and sorted by record number:

XML code is concatenated into one line:

The Batch Macro is used to modify the XML code and create the chart:

The Output