Dynamic Charts

Introduction

Small multiple charts is a term popularised by Edward Tufte. They allow comparing data series as they are repeated for different members.

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.

Video demonstration

For a tutorial, try watching our Small Multiple Videos

UI

As mentioned previously it can be difficult to understand outliers, trends etc when the data is presented as just numbers and text as can be seen below. Using Small Multiples with this example below will guide you through creating meaningful information from the data.

As you can see the desired end point is a much easier way of viewing the data

Let's work through an example.

Category – defines the Category (X Axis) within each individual Chart, in this case a Trend over Time

The Series defines the number of data series to be charted.