Excel Charts - Sparklines


Advertisements

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

Sparklines have the following types −

  • Line Sparkline
  • Column Sparkline
  • Win/Loss Sparkline

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

Sparklines with Quick Analysis

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

Follow the steps given below.

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

Sparklines with Quick Analysis

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

Quick Analysis

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

  • FORMATTING
  • CHARTS
  • TOTALS
  • TABLES
  • SPARKLINES
Quick Analysis Toolbar

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

Sparklines

Line Sparkline – with Quick Analysis Toolbar

Step 4 − Click the Line button. A line chart for each row is displayed.

Sparklines Line Chart

Column Sparkline – with Quick Analysis Toolbar

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

Column Sparkline

Win/Loss Sparkline – with Quick Analysis Toolbar

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

Win/Loss Sparkline

Sparklines with INSERT tab

When you add Sparklines with INSERT tab on the Ribbon, you can show the Sparklines 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 Sparklines through the Insert tab.

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

  • Line
  • Column
  • Win/Loss
Sparklines with INSERT tab

Line Sparkline through INSERT tab on Ribbon

Step 2 − Click the Line option. A Create Sparklines 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.

Line Sparkline

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

Location Range

Step 5 − Click OK.

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

Sparkline Line Charts

Column Sparkline – with INSERT tab on Ribbon

Step 1 − Click the INSERT tab on the Ribbon.

Step 2 − Click the Column button in the Sparklines group on the Ribbon.

Column Sparkline with INSERT tab

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

Step 3 − Select the data range.

Data Range

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

Sparklines Placing

Step 5 − Click OK.

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

Selected Location

Win/Loss Sparkline – with INSERT tab on Ribbon

Step 1 − Click the INSERT tab on the Ribbon.

Step 2 − Click the Win/Loss button in the Sparklines group on the Ribbon.

Win/Loss Sparkline with INSERT tab

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

Step 3 − Select the data range.

Select Data Range

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

Select Location Range

Step 5 − Click OK.

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

Win/Loss Chart
Advertisements