Site icon ExcelNotes

How to Insert Column Sparklines in Excel

The column sparkline is one of the mini charts that are in a single cell, representing the trend of your data. It is similar to the Win/Loss sparkline. Please follow the steps below to add column sparklines:

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

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

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

Step 4: Select the data range that you want to insert the column 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.

Exit mobile version