Excel Course: Inserting Sparkline Graphs

A sparkline graph is a graph small enough to fil in a cell (sparkline graphs are not available for versions of Excel lower than 2010).

To insert a graph, select the cell in which you would like it to appear and choose a graph style.

insert sparkline - excel sparkline graphs

Select the range of source data and press OK.

select range - excel sparkline graphs

The graph has been inserted.

display sparkline - excel sparkline graphs

You can AutoFill the graph onto the following rows.

fill sparkline - excel sparkline graphs sparkline fill - excel sparkline graphs

The "Design" tab allows you to edit the graph's formatting.

edit style - excel sparkline graphs

Sample formatting:

sparkline examples - excel sparkline graphs
Download PDF files of this course