Combine Pivot Charts

Hi All,

Please see attached, I have some data in 'Data' tab which shows values before and after improvements for different categories. I changed the data into 2 pivot table (before and after), see 'Pvt Tables' tab, and created 2 pivot charts from it (before and after), see 'Before Chart' and 'After Chart' tabs respectively.

Is there a way to display both charts into one i.e. a line showing before values and a line showing after values as a pivot chart. If no, how can I move both charts into a single sheet so I can show them next to each other rather than into different sheets (apart from copy and paste charts manually).

I appreciate every help and tips. Thanks

Hi

the data order is not good, thats why you run into an issue in the analysis. Normalization is the keyword.
I copied the after improvement down, added a new column with Before/After. With this setup its easy to show the graph. Just put the STATUS into the Column field of the pivot and you are done.

Thanks for your help hansolu