Excel Worksheet with Inline Charts with Sparklines (Part 2)

In a previous entry I talked a little bit about an old way to embed create charts inside Excel cells (as appose to having the charts float on top of the sheet).  In this entry I will demonstrate the Sparklines cool ability. Sparklines are built-in ability to do the same but much simpler and much nicer. I believe Spaklines are relatively new and were introduced in Excel 2010.

The goal of the feature is to embed a mini-chart inside a cell so your datasheets become more visually pleasing without going to the extra sophisticated workarounds that we’ve all developed over the years.

So this is how it works…Let’s say that we have a simple Year-Over-Year datasheet and we want to add column E with embedded charts:

2013-12 Excel Worksheets with Inline Charts & Graphs (Part 2).1

Select cell E2 and click on the Ribbon menu on “Insert”. You can see that right next to the Charts option there is a box called Sparklines. Like this:

2013-12 Excel Worksheets with Inline Charts & Graphs (Part 2).2

Click on the line option. You will be prompt to a Data Range dialog so specify A2:D2 like the following:

2013-12 Excel Worksheets with Inline Charts & Graphs (Part 2).3

Copy the same from E2 to the rest of the E column and you should get the following result:

2013-12 Excel Worksheets with Inline Charts & Graphs (Part 2).4

You can as easily do the same with Column chart:

2013-12 Excel Worksheets with Inline Charts & Graphs (Part 2).5

The nice thing is that this is part of the Excel Sheet and not an overlay. It is also very easy to do and provides your Excel Sheets a little bit more clarity and visual representation.

Advertisements

Author: dave

Consider myself kid in soul and naive by choice. I am interested in people, technology and business and thrive when they all work together. My favorite quote and motto is that “You can fool some people some times but you cant fool all the people all the time” ― Bob Marley

1 thought on “Excel Worksheet with Inline Charts with Sparklines (Part 2)”

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