Include Sparkline with Pivot Table

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.