Line Graph & Column Bars [Sparklines]

Excel 2010 includes a feature of analyzing data through Sparklines and Column bars, this could be very beneficial if you want to see the trends, and comparisons of each record in pictorial representation. It actually summarizes one complete record and shows it in a single cell through simple line graph and column bars, this post covers the basic usage and elaborates how they logically relate with the data.

Launch Excel 2010, and create a datasheet or open existing datasheet to apply spark lines and columns over the data.

For Instance, we have included datasheet in Excel, which contains student records.

Now we want to create spark lines & columns to visually analyze each student data. Select the portion of the datasheet, against which you want to show spark lines and column bars, navigate to Insert tab, and from Sparklines, click Lines.

lines 1

You will reach Create Sparklines dialog, it shows the range of cells you selected in the data field (B2:H2).

spark lines 34

Click in the Location Range field, and then click the cell on the worksheet you want sparkline to appear. Click OK to analyze visually analyze the student record.

location of spark line 1

Sparkline will appear as you can see from the screenshot below. Now drag the plus sign at the end of it’s cell, towards the end of the column to apply Sparkline on each record.

all cells 1

To make the sparklines more prominent, navigate to Design tab, enable Markers and First Point from Show box, here you can also apply more styles and designs over them.

design spark lines 1

Spark lines cmplte]

Now For creating Column bar for each record , click Column button and then follow the same procedure mentioned above. As you can see in the screenshot below that we have generated Spark Lines and Columns for each student record.


You can also try out previously reviewed SUMIF Function In Excel 2010 and Data Input Forms .

قالب وردپرس

About Alyse Kalish

Alyse Kalish
As an Associate Editor for The SalesJobInfo, Alyse is proud to prove that yes, English majors can change the world. She calls many places home, including Illinois where she grew up and the small town of Hamilton where she attended Colgate University, but she was born to be a New Yorker. In addition to being an avid writer, Alyse loves to dance, both professionally and while waiting for the subway.

Leave a Reply

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