Excel Sparklines

Be Trendy!

Sparklines

Sparklines are an easy way to add visual trend-lines to your tabular data.
And what better way to distract your audience than by dangling something sparkly in front of them!

Watch this 60 second video to learn the what you need to know.

Inserting Sparklines to your Excel data

  1. On the Insert tab, in the Sparklines group, click Sparkline type (e.g., Line). The Create Sparklines dialog appears.
  2. In the Data Range field enter the values to be charted.
  3. In the Location Range field enter cell range where char is to be displayed.
  4. Click OK.

Tip: With an inserted sparkline selected, the Sparklines Tools: Design tab appears on the Ribbon. Use the tools on this tab to change colors and add markers.

Cheers!

hɔuᴉnb

Additional reading:

Comments and questions are always welcome!

Advertisements

Author: quincy harley jr

Quincy is a technophile, coach and Learning Development expert. He has an extensive legal IT background and is practiced in MS Office application support and product development. As a project leader he has been integral in numerous new application rollouts. Whatever spare time he has, is spent with reading, archery and watching his young sons grow.

2 thoughts on “Excel Sparklines”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s