Grid Charts

Revision as of 10:57, 30 September 2010 by Antonio.remedios (talk | contribs) (Show All Members)

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.

Chart Types

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 shows details of the entire visible Grid:


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.