Excel Charts - Sparkpnes

Sparkpnes are tiny charts placed in single cells, each representing a row of data in your selection. They provide a quick way to see trends.

Sparkpnes have the following types −

Line Sparkpne

Column Sparkpne

Win/Loss Sparkpne

In this chapter, you will understand the different types of Sparkpnes and the way to add them to your data. You can add Sparkpnes through the Quick Analysis tool or through the INSERT tab on the Ribbon.

Sparkpnes with Quick Analysis

With Quick Analysis Tool, you can show the Sparkpnes alongside your data in the Excel data table.

Follow the steps given below.

Step 1 − Select the data for which you want to add Sparkpnes. Keep an empty column to the right side of the data for the Sparkpnes.

The Quick Analysis icon appears at the bottom right of your selected data.

Step 2 − Cpck the Quick Analysis button that appears (or press CRTL+Q). The Quick Analysis Toolbar appears with the following options

FORMATTING

CHARTS

TOTALS

TABLES

SPARKLINES

Step 3 − Cpck SPARKLINES. The chart options displayed are based on the data and may vary.

Line Sparkpne – with Quick Analysis Toolbar

Step 4 − Cpck the Line button. A pne chart for each row is displayed.

Column Sparkpne – with Quick Analysis Toolbar

Step 5 − Cpck the Column button. A column chart for each row is displayed.

Win/Loss Sparkpne – with Quick Analysis Toolbar

Step 6 − Cpck the Win/Loss button. A win/loss chart for each row is displayed.

Sparkpnes with INSERT tab

When you add Sparkpnes with INSERT tab on the Ribbon, you can show the Sparkpnes either alongside your data in the Excel data table as you had seen with Quick Analysis tool or in any location that you can choose on the worksheet.

Follow the steps given to add Sparkpnes through the Insert tab.

Step 1 − Cpck the INSERT tab on the Ribbon. The Sparkpnes group appears on the Ribbon, with three tabs −

Line

Column

Win/Loss

Line Sparkpne through INSERT tab on Ribbon

Step 2 − Cpck the Line option. A Create Sparkpnes window appears. It will have placeholders for the data range and the location range.

Step 3 − Select Data Range or type the data range in the box.

Step 4 − Select the Location range where you want the Sparkpnes to be placed.

Step 5 − Cpck OK.

A pne chart for each row of the selected data is displayed at the selected location.

Column Sparkpne – with INSERT tab on Ribbon

Step 1 − Cpck the INSERT tab on the Ribbon.

Step 2 − Cpck the Column button in the Sparkpnes group on the Ribbon.

A Create Sparkpnes window appears, with placeholders for data range and location range.

Step 3 − Select the data range.

Step 4 − Select the location range where you want the Sparkpnes to be placed.

Step 5 − Cpck OK.

A column chart for each row of the selected data is displayed at the selected location.

Win/Loss Sparkpne – with INSERT tab on Ribbon

Step 1 − Cpck the INSERT tab on the Ribbon.

Step 2 − Cpck the Win/Loss button in the Sparkpnes group on the Ribbon.

A Create Sparkpnes window appears, with placeholders for data range and location range.

Step 3 − Select the data range.

Step 4 − Select the Location Range where you want the Sparkpnes to be placed.

Step 5 − Cpck OK.

A Win/Loss chart for each row of the selected data is displayed at the selected location.