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.

DOWNLOAD EXCEL WORKBOOK

 

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

 

Helpful Resource:

Excel Pivot Table

 

4

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin