Now that we have the basics down, let’s toss in some more data and spruce up the Sparklines a bit. I’ve added in a few more rows of data. The first row still shows our months over the course of a year. Rows 2-4 are sales numbers from three different departments. The last row will be an overall percentage for the store we’re using in our scenario. I’ve added basic Sparklines to each row but it could still use some pizazz (Figure 4)!
The first thing we’ll do is to make the Sparkline larger by expanding the column that the chart resides in. I will also group each of the Sparklines so any formatting and styles I apply will apply to all four charts. Simply select all the charts and click the Group button on the Sparklines tab.
I also want to highlight the high, low and negative points so once again I select the grouping of charts and click the High, Low and Negative point buttons. By default all three points will be the same color so I select the charts and use the Marker Color button to specify green for the high point, yellow for the low point and red for negative points.
As you can see in Figure 5 the end result can easily convey information to any viewer. They can easily see the trends for each category of sales without the need to dig into the numbers. The best thing is that Sparklines are part of the cell so they can be printed out or saved to PDF along with the rest of the data.
Don’t be afraid to toy around with the various options – do your audience a favor and include some Sparkline to liven things up in your next Spreadsheet!
Download a sample spreadsheet here.