Small Multiple Charts based on Excel Ranges

From v7.5, XLCubed has the ability to create Small Multiple Charts from data found on your Excel worksheet. To insert a new chart:

  1. Select the XLCubed > Insert > Small Multiples > Excel... ribbon item
  2. Select the data source, if it has not already been selected for you SMCRange1.png SMCRange2.png
  3. Tick the Read data in hidden cells option if you would like all rows to be charted, whether they are visible or not
  4. XLCubed will then insert an empty chart for you, ready for your columns selections
  5. In this example, we can then drag MonthName to Categories, Category to Columns and Color to Rows to give this chart: SMCRange3.png

These small multiple charts are identical to the Analysis Services based charts described on the Small Multiple Charts page, except for a few differences:

  • There is no Header area: the charts are always based on the entire data set
  • Any numeric column can be selected for the Y Axis values. When appropriate, this also applies to X Axis and Colour values.
  • To edit the range, you may click the Select data source toolbar button in the Task Pane: SelectExcelRangeIcon.png
  • To quickly change whether hidden data should be included in the chart, you can use the Read data in hidden cells toolbar button in the Task Pane: IncludeHiddenData.png

See Also