Include Sparkline with Pivot Table

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:

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

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

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

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

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

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

You now have sparklines for your Pivot Table!

How to Include Sparkline with Pivot Table

Helpful Resource:

Bryan

Bryan Hong is an IT Software Developer for more than 10 years and has the following certifications: Microsoft Certified Professional Developer (MCPD): Web Developer, Microsoft Certified Technology Specialist (MCTS): Windows Applications, Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Systems Administrator (MCSA).

He is also an Amazon #1 bestselling author of 4 Microsoft Excel books and a teacher of Microsoft Excel & Office at the MyExecelOnline Academy Online Course.