Page 561 - Excel 2013 All-in-One For Dummies

Adding Sparkline Graphics to a Worksheet 543
When creating a sparkline that spans more than a single cell, the Location Range must match the Data Range in terms of the same amount of rows and columns. (In other words, they need to be arrays of equal size and shape.)
Because sparklines are so small, you can easily add them to the cells in the final column of a table of data. That way, the sparklines can depict the data visually and enhance their meaning while remaining an integral part of the table whose data they epitomize.
Figure 1-13 shows you a worksheet data table after adding sparklines to the table’s final column. These sparklines depict the variation in the sales over four quarters as tiny line graphs. As you can see in this figure, when you add sparklines to your worksheet, Excel 2013 adds a Design tab to the Ribbon under Sparkline Tools.
This Design tab contains buttons that you can use to edit the type, style, and format of the sparklines. The final group (called Group) on this Design tab enables you to band together a range of sparklines into a single group that can share the same axis and/or minimum or maximum values (selected using the options on its Axis drop-down button). This is very useful when you want a collection of different sparklines to all share the same charting parameters so that they equally represent the trends in the data.
Figure 1-13:
Sparklines graphics representing the variation in the
data in a worksheet table as tiny Line charts.
Book V Chapter 1
Charting Worksheet Data