Combine Pivot chart

[vaidmohammed]

Hi,
Attached is an excel where I have shared some data (Data worksheet) and have created 2 Pivot tables (Report worksheet).
1 is columnar pivot chart (issues reported) and another one is line pivot chart (issues closed).

I want a single chart showing both pivots data. ie. a single pivot chart showing issues open as well as issues closed.

Please help me.

 

[Chihiro]

You can't combine two separate pivot tables in single pivot chart.

If you don't have PowerQuery & PowerPivot, I probably won't use Pivot table, but rather go with formula method to aggregate data (or take info from pivot tables and into regular range/table). Then base chart off of it.

Pivot Chart is explicitly tied to the source pivot table and has many limitations which can't be overridden.

 

[NARAYANK991]

Hi ,

As an example of what Chihiro has mentioned , see this link :

https://www.myonlinetraininghub.com/creating-excel-charts-from-multiple-pivottables

Narayan

 

[GraH - Guido]

You can't combine two separate pivot tables in single pivot chart.

But I believe I just did...
ALT + D + P (consolidate ranges, can be pivot ranges)

Honestly, the better solution has already been provided.

 

[Chihiro]

But I believe I just did...

I know it's semantics, but you are combining two pivot tables into single pivot table, then using that single pivot table as source for chart.

Not two pivot table consolidated into single pivot chart.

At any rate, as far as I can tell, OP needs Opened and Closed separated within the same chart (bar chart & line chart). Combo chart in this manner is best done using method outlined in Narayank's link.

 

[GraH - Guido]

I know it's semantics, but you are combining two pivot tables into single pivot table, then using that single pivot table as source for chart.
Not two pivot table consolidated into single pivot chart.
Combo chart in this manner is best done using method outlined in Narayank's link.

I did say

Honestly, the better solution has already been provided.