Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Pivot chart based on summary column

Copper Contributor

Hello,

 

I have pivot table with several categories (rows) by years (columns). Table looks fine.

 

I have created the pie chart. It automatically shows only the first year of 2022 (column) of the pivot chart.

MartinDlabac_0-1704641504482.png

 

Is there a way how can I change this to the total of all years (purple) to be displayed in pie chart, while table displays all the years including the total column at the end?  

 

Many thanks, Martin

1 Reply

@MartinDlabac 

Create a second pivot table based on the same data.

Add the product to the Rows area and the profit to the Values area.

Do not add the year to this pivot table.

Create the pivot chart from the new pivot table.