How to Insert Line Sparklines

Line sparkline is one of the mini charts in a single cell, representing the trend of the data you selected. Please follow the steps below to add line sparklines:

Step 1: Click the cells that you want to insert the line sparklines, mostly the cells right after the data range;

Step 2: Click the "Insert" tab from the ribbon;

Step 3: Click the "Line" command from "Sparklines" section;

Step 4: Select the data range that you want to insert the line sparklines (e.g., A1:D3);

Step 5: Click "OK" at the bottom and you will see the charts in the cells;

Step 6: If you want to change the color, click the "Sparkline" tab from the ribbon;

Step 7: Click "Sparkline color" and select one color from the theme colors;

Step 8: For example, select the "Light blue" color.

Leave a Reply