Grid Charts introduce truly dynamic charting to XLCubed. One or more Grid charts can be tied to each Grid. You have the ability to specify the level being charted (Entire Grid / Specific Level / Lowest Level) as shown below, and the charts will change, grow and shrink with the Grid. Once created, the Grid chart can be sized and formatted as with a standard Excel chart.
To create a Grid Chart, right-click on a Grid and choose XLCubed > Grid Charts and then the type of Chart.
Show Lowest Members
This option charts the cross-section of the lowest levels in the Grid:
Show All Members
This option creates a Grid chart which details the entire Grid data:
Show at Selected Levels
The levels option allows you to select which levels of the Grid hierarchies are used for the chart:
Configuring Existing Charts
Right-clicking a Grid and choosing XLCubed > Grid Charts > Manage Grid Charts... allows you to change the chart type and what members are being charted.