How to Make Sparklines in Excel 2007

A sparkline is a very small line chart that is typically drawn without axes or coordinates. It presents the general shape of the variation (typically over time) in some measurement in a simple and highly condensed way. Sparklines are small enough to be embedded in text or several sparklines may be grouped together as elements of a small multiple. (Please see example in Excel Worksheet).

How to Make Sparklines 01

Making Sparklines

How to Make Sparklines 02

Step 1: Highlight cells B4 through M4 and click the Insert tab. Click the Charts menu.

How to Make Sparklines 03

Step 2: Click the Line option and select the 2D line chart, which is the first option.

How to Make Sparklines 04

How to Make Sparklines 05

Step 3: Click the legend and press the delete key.

How to Make Sparklines 06

Step 4: Click the horizontal axis and press the delete key. Click the Vertical Axis and press the delete key.

How to Make Sparklines 07

Step 5: Click the horizontal grid lines and press the delete key.

How to Make Sparklines 08

Step 6: Resize the chart. Click the chart and drag the handles to the desired size.

Step 7: Create chart for the Expense line and Profit Line: Click the revenue chart and press control D to create a copy.

Step 8: Click the line in the new chart. The referenced data for the Revenue will be highlighted above. Hover the mouse around the highlighted data until you see the cross change to arrows. Click on the arrows and drag down to the next line of data. The Expense data will now be reflected in the chart. Repeat these steps for the Profit data.

How to Make Sparklines 09

Step 9: Add titles to the left of your sparklines.

How to Make Sparklines 10

This entry was posted in Excel Tips & Tricks. Bookmark the permalink.

11 Responses to How to Make Sparklines in Excel 2007

  1. Kris says:

    Very helpful–thanks!

  2. Bachir says:

    Thanks for the tip, I still have excel 2007

  3. Karen says:

    This was oh so very helpful. Thank you so much Kathy.

  4. Nadia says:

    At the moment I deal with question, how to insert sparklines. Thanks, now I came the answer a piece closer. This site also supportes me very well in my problem-asks:

  5. Travis says:

    Thank you.

  6. Pingback: Tennis Players sample data

  7. Nicole Keller says:

    awesome. thanks.

  8. myla paran says:

    Thank you… It really helped me a lot

  9. Lise says:

    Thank you so much, very helpful!! Bless you Kathy

  10. madhu says:

    thanks, it helped me a lot, i am learning how to work in spreadsheet

  11. Nice, elegant solution

Leave a Reply

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

8 − = zero