Question
How do I add a sparkline in Excel?
Answer
Sparklines permit the user to display general trends within one's data without having to produce a full-blown chart or graph. Sparklines are essentially a mini-graph contained in a single cell representative of the proceeding cells in that corresponding row.
- To add a sparkline simply refer back to your original data, go to the Insert tab, in the Sparklines group and select either a line, column or win/loss sparkline by clicking on the appropriate icon.
- After you have selected the sparkline to add a “Create Sparklines” dialog box will appear prompting you to select the Data Range and Location Range. For the Data Range, make sure your cursor is blinking in the data range box and click and drag over the data you want to select and release. You should see the Data Range box is now populated with the cells previously selected. Next, is the Location Range this is where you will select where you want the Sparklines to be placed. Again, make sure your cursor is blinking in the Location Range box, click and drag over the cells and release. The Location Range box will be automatically populated.
- Click ok.
- The Sparklines will appear in the cells previously selected. A new toolbar will also appear called Sparkline Tools.
For more information about Charts and Graphs in Excel, please view the full tutorial from the CTL here: Excel Part 2
If you need further assistance, please click the CTL Support Request button on this page.