Active Member
Xtreme Pivot Tables
Excel for Finance
May 26, 2016
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??
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
November 8, 2013
Active Member
Xtreme Pivot Tables
Excel for Finance
May 26, 2016
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
November 8, 2013
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.myonlinetraininghu.....ivottables
Creating a regular chart is a good alternative, and you will also be able to use the pivot table slicers to filter the chart.
1 Guest(s)