Register
Log In
Unanswered
Home
New Member
June 26, 2016
Offline
I have a chart which is linked to a pivot table & also controlled through multiple slicers working on the same pivot data, however whenever I am refreshing my data (after making small changes in it such as revising a value, adding a row etc...) all the formatting which i did with the chart goes off the track. I want some data specifically plotted on primary axis (as column chart) & some on secondary axis (as line chart), whereas after refreshing all the data values get plotted on the primary axis (as column chart only).
Any help on the above will be highly appreciated.
July 16, 2010
Offline
Unfortunately this is a known bug in PivotCharts.
You could try saving your formatting etc. as a Chart Template and then apply the template again each time the formatting gets messed up. The other options are to use a regular chart linked to either a manual chart table, or use dynamic named ranges linked to the PivotTable as your 'regular' chart source data.
Excel for Decision Making
January 29, 2015
Offline
In the past, I've used a macros to automatically update the chart. You will need to create a template first. You can set up your macros to update the chart once data has been entered or when the spreadsheet first opens, or whenever you want. This is what I've used in the past.
ActiveSheet.ChartObjects("Chart 1").Select
ActiveChart.ApplyChartTemplate ("C:Location Name of template\KPI.crtx")
Most Users Ever Online: 57
Currently Online: clark shao
15 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:
Md. Rahman
Lilian Vo
Jane Kumwenda
David Miller
Efe Onwochei
LynAnn Williams
Brandy Kriger
purna chandar
E K
velissa barr
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
