Excel Training: Sparkline Charts
The sparkline chart is a miniature chart inserted directly into a cell.
The purpose of a sparkline chart is to provide a visual representation of the data in a row (or column) as a chart.
Insert a sparkline chart
To add a chart to the right of the following table (lesson-7b.xlsx), click on the "Insert" tab and choose one of the 3 proposed sparkline chart types.
Start by inserting a "Line" sparkline chart:
Select the chart's data row and validate:
Then copy the chart downwards:
Customize the sparkline chart
You can customize the appearance of the charts from the "Design" tab:
You can also change the chart type from this tab:
To highlight certain points of the chart, check the points to display and if necessary modify their color, like here with the display of the "High Point" in green:
The "Win/Loss" sparkline chart
This last type of chart is more simplistic and allows only to visualize if the values are positive or negative: