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
Bookmarks