Sparklines

Mar 22 / Michelle Unger
Step 1) Select your desired cell

Step 2) Press Alt + N + S + L (this is the shortcut for inserting a line chart into your spreadsheet)

Step 3) Select the data (B2:F2) and press Enter

Step 4) Go to Sparklines > Column

Step 5) Drag down to copy for remaining cells

Step 6) Highlight the entire row for each row with a bar chart. Drag down to increase the height of each highlighted row

Watch the video to see the steps.
Sparklines are easy-to-read mini-charts that live inside your cells to help your Excel data come to life.

Created with