Pinterest Pixel

Include Sparkline with Pivot Table

Once you have your Pivot Table ready and setup, you want to add something more graphical beside... read more

Download Excel Workbook
Bryan
Posted on

Overview

Include Sparkline with Pivot Table | MyExcelOnline Include Sparkline with Pivot Table | MyExcelOnline

Once you have your Pivot Table ready and setup, you want to add something more graphical beside your data points. We have just the thing for you, you can include sparkline with pivot tables!

Here we have our Pivot Table ready:

Include Sparkline with Pivot Table

See how you can do this in just a couple of steps.

Include Sparkline with Pivot Table | MyExcelOnline

Download excel workbookInclude-Sparkline-with-Pivot-Table.xlsx

 

STEP 1: Select a spot right beside your Pivot Table. Go to Insert > Sparklines > Line

Include Sparkline with Pivot Table

We want to create a sparkline based on our first row of data. Select the sales values of 2013-2015. Then click OK.

Include Sparkline with Pivot Table

 

STEP 2: On the lower right corner, drag it all the way down to populate the rest of your table with sparklines.

Include Sparkline with Pivot Table

 

STEP 3: We can change the type as well. Go to Sparklines Tools > Design >Type > Column

Include Sparkline with Pivot Table

You now have sparklines for your Pivot Table!

Include Sparkline with Pivot Table

 

How to Include Sparkline with Pivot Table

See also  How to Lock the Excel Pivot Table | A Detailed Tutorial

 

Helpful Resource:

Excel Pivot Table

 

If you like this Excel tip, please share it
Include Sparkline with Pivot Table | MyExcelOnline Include Sparkline with Pivot Table | MyExcelOnline
Include Sparkline with Pivot Table | MyExcelOnline
Bryan

Bryan is a best-selling book author of the 101 Excel Series paperback books.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...