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.
Click cell N2. Switch to Insert tab and find Sparklines section.
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.
You can then select the range of data you want the chart to contain manually.
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.
The mini chart is created in the cell N2.
You can still edit it in Design tab like adjusting the data range, chart type or style.
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.
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.