Combine multiple pivots tables into one pivot chart

[obrien918]

This is my first post on this site or any forum so I hope my question makes sense. I have created two pivot tables with data from 2016 and from 2017. I would like to combine the results of those tables into one chart. Is there a way to do this?

[sandy666]

Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.
Include in the attachment any code you're currently using (whether it works or not) and an After of what you wish the output to be.

To attach a Excel file to your post,

• click Go Advanced,
• scroll down until you see Manage Attachments,
• click that and select Browse,
• select your file and click Open,
• click Upload and you will see your attachment below Upload Files from a website
• click Close this window,
• click Submit reply

After that you should see attachment in your post
Note: I said attach example file but I didn't say I will help.

Maybe read here: Creating Excel Charts from Multiple PivotTables