Difference between revisions of "Small Multiple Charts based on Excel Ranges"

(Created page with "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 {{Menu|XLCubed|Insert|Small M...")
 
 
Line 10: Line 10:
 
* There is no Header area: the charts are always based on the entire data set
 
* 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.
 
* 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 {{Menu|Select data source}} toolbar button in the Task Pane: [[File:SelectExcelRangeIcon.png]]
 +
* To quickly change whether hidden data should be included in the chart, you can use the {{Menu|Read data in hidden cells}} toolbar button in the Task Pane: [[File:IncludeHiddenData.png]]
  
 
==See Also==
 
==See Also==
 
* [[Small Multiple Charts]]
 
* [[Small Multiple Charts]]
 +
* [[Small Multiple Charts based on SQL]]
  
 
[[Category:Small Multiple Charts]]
 
[[Category:Small Multiple Charts]]

Latest revision as of 17:35, 21 June 2013

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