This may have been solved or addressed previously but I haven't been able to find the appropriate forum.
I have a pivot table which sorts by 2 groups of data (with multiple sub-data), years and quarters, and has two sets of values (Won/lost).
I want to generate multiple different pivot charts which represent different aspects of the same pivot table and change accordingly.
For example I have one stacked column chart to display won/lost per sub-group. But I would also like to include Line charts, pie charts, bar charts which represents the data differently.
For example I would like the pie chart to just show the grand totals, and show by percentage. Or for the line chart, the X axis should represent the years (not sub-group) and show a trend over years.
I am struggling to find out how this is approached.
Thanks for help in advance.
Bookmarks