Pivot Table and Chart with slicer

[wesp15]

Hey all,

I have created a pivot table and accompanying chart (not pivot) with slicers in order to filter on my data by defined criteria area. I currently have the data setup to display in a stacked bar chart on one y axis and a stacked area chart on another (See below). Unfortunately i am having some trouble with the data manipulation and i'm hoping someone can help:

1. For some reason when i use the slicers to filter the data the stacked column chart displays fine but the stacked area chart adds a "grand total" area that is misleading. This would be easy enough to turn off by removing the totals from the pivot table but i also want to add a total line on top of the other displays. (See the upper most grey area in chart 2)
2. I am also having issues with the aforementioned 'Grand Total" display. Because the pivot table display shifts based on the slicers the chart is unable to maintain the releationship to the grand total column and it gets erased based on the filter. (See the removal of the total line in graph 2)

Hopefully, my descriptions are clear. I'm happy to further elaborate if they are not. I'm also happy to provide the file if that would be of help.

Thanks for any guidance you can provide!

 

[wesp15]

Re: Pivot Table and Chart with slicer - Help

Updated Image HyperLink: (https://imgur.com/a/dsLWT)