Register
Log In
Unanswered
Home
New Member
April 24, 2015
Offline
Hello friends,
I have been struggling with this one. I have created a pareto chart using the combo option. The underlying data comes from a data model that connects multiple pivot tables. The charts are controlled by a slicer.
However, when I move from one item on the slicer to the other, the data type changes to bar graphs and the secondary axis vanishes. How do I ensure the combo settings for pareto is maintained when I select different items on the slicer.
Regards,
July 16, 2010
Online
Hi Anthony,
Unfortunately this is a known bug with Pivot Charts 🙁 The workaround is to create a regular chart from your PivotTable. I wrote about how to do that here: https://www.myonlinetraininghub.com/create-regular-excel-charts-from-pivottables
Kind regards,
Mynda
Most Users Ever Online: 57
Currently Online: Mynda Treacy
16 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
sugi gunawan
janja mesec
John DiMartino
lizette acosta
eric johnson
Kim Bond
Nichelle Stevens
Manuel Rodriguez
peter wang
Amit Kanekar
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
