Slider

How to Insert Sparklines into Excel Cells

Date:2019-7-30 Author:Cordelia

Sparklines is a chart making tool in Excel (from Excel 2010). It takes cells as the drawing area to create simple and small graphs, which can present the data to readers more intuitively. Let's see how to insert a mini chart inside the cell.

The table below shows the incomes of A and B from January to December. Now I want a more intuitive view of the variations. So I choose the cell N2 as the location to output the mini chart for A, and N3 for B.

How to Insert Sparklines into Excel Cells

Click cell N2. Switch to Insert tab and find Sparklines section.

How to Insert Sparklines into Excel Cells

Choose a type suits your situation. In my case I choose Line in the left. Then click the small icon besides the textbox of Data Range in Create Sparklines window.

How to Insert Sparklines into Excel Cells

You can then select the range of data you want the chart to contain manually.

How to Insert Sparklines into Excel Cells

Click the icon besides the textbox again. You'll be back to the Create Sparklines window and the textbox of Data Range is already filled. Hit OK to apply the settings to your table.

How to Insert Sparklines into Excel Cells

The mini chart is created in the cell N2.

How to Insert Sparklines into Excel Cells

You can still edit it in Design tab like adjusting the data range, chart type or style.

How to Insert Sparklines into Excel Cells

If you think the small chart is not intuitive enough and want to make the focal points stand out, try check different points in Show section. For me, I choose to emphasize the High Point and Low point. You can also check Markers to add point to the data of each month.

How to Insert Sparklines into Excel Cells

Please note the Sparklines added in this way can't be deleted directly. But you can select them and simply click Clear in the Design tab. Thus they will be removed right away.

How to Insert Sparklines into Excel Cells

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *