Register
Log In
Unanswered
Home
Xtreme Pivot Tables
Excel for Finance
May 26, 2016
Offline
I am trying to represent a combined bar and line graph, showing revenue as the bar graph and each expense type as a line graph. The idea to see where expenses visually are above revenue, the problem is when i try and filter on the pivot or via the slicer the expense type the entire graph returns to a bar graph as per Graph 2.
Please help and advise how i overcome this problem, preferably without using any VBA coding, but rather the normal functions/tools of pivot table/pivot charts??
November 8, 2013
Offline
Unfortunately, it's a known bug with no solution yet. If you choose one of the suggested layouts, this will not happen.
The only way is to use vba .
Xtreme Pivot Tables
Excel for Finance
May 26, 2016
Offline
Hi Catalin, what do you mean when you say choose a suggested layout?
I am not very well versed in in VBA, therefore have always tried to stay away from it. Do you perhaps have some standard coding that that I can apply that will overcome this problem?Â
November 8, 2013
Offline
Hi Kevin
In Pivot Table Tools ribbon tab, in Design tab, there is a predefined set of Chart Styles. If you use one of those, excel will not change the settings after filtering.
Here is a good article describing the problem: http://peltiertech.com/pivot-c.....g-changes/
This tutorial might help too: https://www.myonlinetraininghub.com/create-regular-excel-charts-from-pivottables
Creating a regular chart is a good alternative, and you will also be able to use the pivot table slicers to filter the chart.
Most Users Ever Online: 57
Currently Online:
12 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:
Stephen Motte
Rodney Hoyle
michael pitre
Samantha Burleson
Krishnaa Kurugod
David McSwain
Shameem Nassiree
Alanna Henderson
Janel Oz
Mohamed Rehan Memon
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
