| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
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:
- Select the XLCubed > Insert > Small Multiples > Excel... ribbon item
- Select the data source, if it has not already been selected for you
- Tick the Read data in hidden cells option if you would like all rows to be charted, whether they are visible or not
- XLCubed will then insert an empty chart for you, ready for your columns selections
- In this example, we can then drag MonthName to Categories, Category to Columns and Color to Rows to give this chart:
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:
- 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:
