Spark Lines in MS Excel 2010 Excel Tips

Spark Lines in MS Excel 2010

Posted Date: 18-Jul-2012	Category: Excel
Author: Nandhini	Member Level: Gold	Points: 10

A SparkLine is basically a small chart displayed in a cell. SparkLines are tiny, word sized charts that can appear in a cell. It enable us to create visual representation of data easily. Use SparkLines to show trends in a series of values such as seasonal increase or decrease, economic cycles etc.,.

Locate SparkLines

In order to locate the SparkLines option

1. Go to --> Insert menu
2. In SparLines choose the type of chart
3. Create SparkLines popup will be displayed
4. Select the Data range
5. Select Location range and
6. Click OK

Color

Color Schema can be applied to the SparkLines by selecting a built-in format from the style gallery. SparkLine color or Marker color can be used to choose a color from high to low.

SparkLines are printed. When you print the worksheet that contains SparkLines.

Design tab

When you select a cell that contain SparkLines, then the Design tab will be displayed in the menu.

Data Markers

We can show Data Markers to highlight individual values.
In the Design Tab select Markers checkbox to show all values.
Select any of the high or low to show individual values.

Handle Empty Cells or Zero values

SparkLine handles empty cells by using Hidden and Empty Cell settings.
In the Design tab
Select Edit Data
Select Hidden and Empty cell Settings
A dialog box will be displayed where we can set to handle empty cells and hidden values.

Post Comment:

Notify me by email when others post comments to this article.

Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.

No HTML formatting and links to other web sites are allowed.

This is a strictly moderated site. Absolutely no spam allowed.

Name:	Sign In to fill automatically.
Email:	(Will not be published, but required to validate comment)
	Type the numbers and letters shown on the left.