Stacked column chart from Pivot table not stacking!!!

[Boubiche]

Hi guys,

I need someone’s brain on this.

Sounds super simple.. but it just doesn’t work when I try it. I looked at all the previous 50 pages of posts with the works Pivot/stacked charts, but couldn’t find help.
I am trying to do as simple stacked chart out of a pivot table. But when I select the ‘stacked’ columns, it still shows me the details of each city.
I just want to see the total for the month.
Can someone please help! I don’t get what im missing! I would be so grateful if you could help..

My pivot could not be simpler: date and location in rows & count in values. I just want to stack the count per location into one single column for the month!!!


Thanks!!

 

[RoryA]

Pivot charts don't plot totals - they plot everything else in the pivot table. If you don't want to see a specific level of detail, you need to remove it from the pivot table.