Grid Charts

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.

Time Series Graphing

This example shows a technique for displaying a time-series graph. It is based on data in Adventure Works cube. You can download the Excel spreadsheet that is used in the example here File:TimeSeriesGraphFromSlicer.zip The report is based on a slicer that allows the user to switch between showing the graph data based on quarters, months or days.

Workbook Sheet - Chart This sheet shows the graph based on the data chosen in slicer above it. This switches the graph data between quarters, months and days depending on the slicer selection.