Creating Sparkline charts in Excel.
When to use
Use to create tiny in-cell charts that give an idea of trends in the data, allowing you to identify potential issues.
Creating a Sparkline
- Lay out your data in either a horizontal or vertical layout
- Select the data you want to chart
- Go to Insert --> Sparklines and choose Line, Column or Win/Loss
- Choose a location for your Sparkline
- Sparklines can be copied via copy and paste or by dragging with the fill handle
- Done via the Sparkline Tools tab (which shows up when you select a cell with a Sparkline)
- Sparkline types can be changed from one style to another
- Highlight different data points by selecting the High, Low (or other) checkboxes
- Modify color combinations by selecting different styles from the Styles gallery
- Take more granular control by setting Sparkline and Marker colors manually
Hints & tips
- You cannot base Sparklines on data that lives in another worksheet
- To allow hiding of your source data, select the Sparkline --> Edit Data --> Hidden and Empty Cells --> Show data in hidden rows and columns
- Remember that a Sparkline is a micro chart only used to expose issues in a data trend
Lesson notes are only available for subscribers.