Use Sparklines to Display Trends in Excel

A sparkline is a tiny chart in the background of a cell. When you use a sparkline, you can easily see the relationships between it and its underlying data. And, you can copy sparklines to adjacent cells by using the Fill Handle. Sparklines are printed as-is when you print a worksheet that contains them, unlike charts that may require special print handling.

Insert a Sparkline

  1. Select the cells that contain the data you want in the sparkline chart.
  2. Select the type of sparkline you want from the Sparklines group [A] on the Insert tab.Sparkline Trend figure 1Sparkline Trend figure 2
  3. In the Create Sparklines dialog box, the cell or range you have selected will be filled in the Data Range: text box [B].
  4. Type where you want your sparkline to go in the Location Range text box [C], or click the destination cell. A selection box will appear around it.
  5. Click the OK button.
  6. The sparkline will appear in the position you designated [D] and the Sparkline Tools highlighted ribbon [E] will become available when the cell is selected.Sparkline Trend figure 3Sparkline Trend figure 4
  7. Copy the sparkline to additional rows or columns using the Fill Handle.
    • Select the sparkline you want to copy, then hover over the Fill Handle until your curser turns to a cross [F].
    • Drag the handle over the cells you want to fill. Sparklines will appear in each of the cells [G].Sparkline Trend figure 5Sparkline Trend figure 6

Pro Tip: Use the Quick Analysis tool to quickly add a sparkline to your data.

PRYOR+ 7-DAYS OF FREE TRAINING


Courses in Customer Service, Excel, HR, Leadership, OSHA and more. No credit card. No commitment. Individuals and teams.


Choose a Seminar and Save $10:

Microsoft<small><sup>®</sup></small> Excel<small><sup>®</sup></small>: Beyond the Basics

Microsoft® Excel®: Beyond the Basics

Mar. 23

Central Time Zone

Mar. 24

Eastern Time Zone

Mar. 28

Central Time Zone

Mar. 29

Eastern Time Zone

Mar. 31

Pacific Time Zone

Apr. 4

Eastern Time Zone

Apr. 5

Pacific Time Zone

Apr. 6

Central Time Zone

Apr. 12

Eastern Time Zone

Apr. 13

Pacific Time Zone

Apr. 14

Central Time Zone

Apr. 18

Central Time Zone

Apr. 20

Eastern Time Zone

Apr. 21

Pacific Time Zone

Apr. 25

Pacific Time Zone

Apr. 26

Central Time Zone

Apr. 28

Eastern Time Zone

May. 2

Eastern Time Zone

May. 3

Pacific Time Zone

May. 5

Central Time Zone

May. 9

Central Time Zone

May. 11

Pacific Time Zone

May. 12

Eastern Time Zone

May. 16

Pacific Time Zone

May. 17

Eastern Time Zone

May. 19

Central Time Zone

May. 23

Central Time Zone

May. 25

Pacific Time Zone

Jun. 1

Eastern Time Zone

Jun. 2

Central Time Zone

Jun. 6

Eastern Time Zone

Jun. 8

Pacific Time Zone

Jun. 9

Central Time Zone

Jun. 13

Central Time Zone

Jun. 14

Pacific Time Zone

Jun. 16

Eastern Time Zone

Jun. 21

Eastern Time Zone

Jun. 22

Central Time Zone

Jun. 23

Pacific Time Zone

Jun. 27

Pacific Time Zone

Jun. 28

Central Time Zone

Jun. 29

Eastern Time Zone

Jul. 6

Eastern Time Zone

Jul. 11

Eastern Time Zone

Jul. 12

Pacific Time Zone

Jul. 14

Central Time Zone

Jul. 18

Central Time Zone

Jul. 19

Eastern Time Zone

Jul. 20

Central Time Zone

Jul. 21

Pacific Time Zone

Jul. 25

Central Time Zone

Jul. 27

Pacific Time Zone

Jul. 28

Eastern Time Zone

Microsoft<small><sup>®</sup></small> Excel<small><sup>®</sup></small> Basics

Microsoft® Excel® Basics

Mar. 23

Eastern Time Zone

Mar. 27

Central Time Zone

Mar. 28

Eastern Time Zone

Mar. 30

Pacific Time Zone

Apr. 3

Eastern Time Zone

Apr. 4

Pacific Time Zone

Apr. 5

Central Time Zone

Apr. 11

Eastern Time Zone

Apr. 12

Pacific Time Zone

Apr. 13

Central Time Zone

Apr. 17

Central Time Zone

Apr. 19

Eastern Time Zone

Apr. 20

Pacific Time Zone

Apr. 24

Pacific Time Zone

Apr. 25

Central Time Zone

Apr. 27

Eastern Time Zone

May. 1

Eastern Time Zone

May. 2

Pacific Time Zone

May. 4

Central Time Zone

May. 8

Central Time Zone

May. 10

Pacific Time Zone

May. 11

Eastern Time Zone

May. 15

Pacific Time Zone

May. 16

Eastern Time Zone

May. 18

Central Time Zone

May. 22

Central Time Zone

May. 24

Pacific Time Zone

May. 31

Eastern Time Zone

Jun. 1

Central Time Zone

Jun. 5

Eastern Time Zone

Jun. 7

Pacific Time Zone

Jun. 8

Central Time Zone

Jun. 12

Central Time Zone

Jun. 13

Pacific Time Zone

Jun. 15

Eastern Time Zone

Jun. 20

Eastern Time Zone

Jun. 21

Central Time Zone

Jun. 22

Pacific Time Zone

Jun. 26

Pacific Time Zone

Jun. 27

Central Time Zone

Jun. 28

Eastern Time Zone

Jul. 5

Eastern Time Zone

Jul. 10

Eastern Time Zone

Jul. 11

Pacific Time Zone

Jul. 13

Central Time Zone

Jul. 17

Central Time Zone

Jul. 18

Eastern Time Zone

Jul. 19

Central Time Zone

Jul. 20

Pacific Time Zone

Jul. 24

Central Time Zone

Jul. 26

Pacific Time Zone

Jul. 27

Eastern Time Zone

Advanced Microsoft<small><sup>®</sup></small> Excel<small><sup>®</sup></small>-Macros, PivotTables, Charts and More

Advanced Microsoft® Excel®-Macros, PivotTables, Charts and More

Mar. 30

Central Time Zone

Mar. 31

Eastern Time Zone

Apr. 4

Central Time Zone

Apr. 13

Eastern Time Zone

Apr. 17

Pacific Time Zone

Apr. 21

Central Time Zone

Apr. 26

Eastern Time Zone

Apr. 27

Pacific Time Zone

May. 1

Central Time Zone

May. 2

Pacific Time Zone

May. 10

Eastern Time Zone

May. 11

Central Time Zone

May. 17

Central Time Zone

May. 18

Eastern Time Zone

May. 23

Pacific Time Zone

Jun. 2

Eastern Time Zone

Jun. 7

Eastern Time Zone

Jun. 9

Central Time Zone

Jun. 13

Pacific Time Zone

Jun. 19

Central Time Zone

Jun. 20

Eastern Time Zone

Jun. 29

Pacific Time Zone

Jul. 5

Pacific Time Zone

Jul. 10

Central Time Zone

Jul. 14

Eastern Time Zone

Jul. 20

Eastern Time Zone

Jul. 25

Central Time Zone

Related Excel® Articles

PRYOR+ 7-DAYS OF FREE TRAINING


Courses in Customer Service, Excel, HR, Leadership, OSHA and more. No credit card. No commitment. Individuals and teams.

Categories