Tiny Charts Help Others to Visualize Your Data
- Adding Sparklines to a Worksheet
- Understanding the Axis Size of Sparklines
- Creating Column Sparklines for High Temperature Data
- Forcing Each Sparkline to Have the Same Scale
- Adding Labels and Shading the Normal Range on a Sparkline
- Adding a Reference Line
- Adding Shading to Show the Normal Range
- Showing Negative Values
- Win/Loss Sparklines
Professor Edward Tufte wrote about sparklines in his 2006 book, Beautiful Evidence. He described them as "data-intense, design-simple, word-sized graphics." The idea is to present a historical trend of data in the space of a typical word. Microsoft added three types of sparklines to Excel 2010.
Consider the data set in the following figure. Take a few seconds and scan the data. Can you easily spot which products are trending up? Trending down? Staying flat? It is pretty tough with just a range of numbers.
Now, look at the same data with the addition of some sparklines in column B. It is now easy to see which products are trending up, down, or staying flat.
The sparklines in column B have the highest month marked in green and the lowest month marked in red. These settings can be achieved using the Sparkline Tools in Excel.
Adding Sparklines to a Worksheet
Follow these steps to add the sparklines shown above:
- Insert a new column B to hold the sparklines.
- Select C2:K10.
- From the Insert tab of the ribbon, choose Sparklines, Line.
- The Data range will be filled in because you pre-selected the data. Select B2:B10 as the Location range.
- Click OK.
- In the Show group, select High Point and Low Point.
- From the Marker Color drop-down, choose High Point and then choose green.
- From the Marker Color drop-down, choose Low Point and then choose red.
- Sparklines will fill the size of the cell. Make column B wider. Make rows 2 through 10 a little taller (about 18).
The initial sparkline will be plain. As long as the sparklines are selected, the Sparkline Tools Design tab of the ribbon will be available.
This will add plain black markers at the high and low point of each sparkline.