XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/

Difference between revisions of "Category:Small Multiple Charts"

(Hierarchy positioning)
(Replaced content with 'This category contains articles about Small Multiple Charts. The main article is Small Multiple Charts.')
 
(10 intermediate revisions by one other user not shown)
Line 1: Line 1:
==Introduction==
+
This category contains articles about Small Multiple Charts.
  
Small multiple charts is a term popularised by Edward Tufte. They allow comparing data series as they are repeated for different members.
+
The main article is [[Small Multiple Charts]].
 
 
In XLCubed they are useful for visualising large amounts of data, as hundreds of data points can be plotted and compared easily.
 
 
 
This allows users to find trends and outliers in the data more easily than by trying to study a large table of data.
 
 
 
 
 
==UI==
 
 
 
To create a small multiple click the menu item on the ribbon/toolbar. A blank chart and the small multiple task pane appear.
 
 
 
The task pane is the designer for you chart, and supports drag drop and the familiar XLCubed Member selector.
 
 
 
===Hierarchy positioning===
 
 
 
On the small multiple pane there are 4 boxes you can drop hierarchies in.
 
 
 
Two are familiar from normal Excel charts. The "Categories" box defines the members that appear on the X-Axis, and the "Series" box defines the members that will display as a separate series.
 
 
 
The "Rows" and "Columns" boxes define how the charts are repeated, best shown by an example
 
 
 
[[File:SmallMultiplesAxes.png|thumb|none|Chart layout]]
 
 
 
==Trends==
 

Latest revision as of 12:28, 14 March 2011

This category contains articles about Small Multiple Charts.

The main article is Small Multiple Charts.