PivotChart only showing first column, not the total.

[miicker]

Hello everyone,

I have a question. I have a PivotChart based on these values:

Those columns are names of the days.

I want a PivotChart that shows me the Colmun total, but now it shows "Dinsdag" (Tuesday).

It shows this:

How can i fix this (I don't want to remove the day column's)
By the way: sometimes it needs to present 4 days, sometimes 2 days, so the day columns can be more or less than in this example.

Can someone please help me to fix this.

Kind regards,
Miicker

 

[RoryA]

You'll have to use another pivot table for the chart that doesn't have the day field.

As an aside, I think a bar or column chart would be a much better choice than a pie chart here.

 

[miicker]

You'll have to use another pivot table for the chart that doesn't have the day field.

As an aside, I think a bar or column chart would be a much better choice than a pie chart here.

Really? Is there a way to make a pivot table, based on that pivot table. I use a lot of slicers and all, so otherwise I would need to duplicate all slicers. Or can I maken 1 slicer for 2 pivottables?
This is an example, normally it is way less data :P

 

[RoryA]

As long as the data source is the same, a slicer can control multiple pivot tables.

A pie chart is rarely the best chart. (the fact you have to label every slice is a bit of a giveaway - you might as well not have a chart. )