Prevent slicer from changing chart type

[jschena]

Hi there,

I have a pivot chart in excel with a few different slicers. My problem is that when I click on some of the slicer options, it changes my chart type (I had a chart with bars as well as a line graph). How can I keep the slicer from changing the chart types?

Thank you!!!

 

[rocksolid77]

*Bump*

I'm having the exact same problem. I have a graph with three different values, two displayed as line graphs on primary axis and and the last as a bar graph on a secondary access. Whenever I use a slicer to manipulate the data it switches the whole graph to one format or another (typically, whichever format I used last) and puts everything back onto one axis. I also noticed that this tends to happen more often if, while filtering, you filter out all the values so that the graph is temporarily blank. Since I have multiple slicers which overlap eachother this happens quite a bit.

 

[jschena]

*Bump*

I'm having the exact same problem. I have a graph with three different values, two displayed as line graphs on primary axis and and the last as a bar graph on a secondary access. Whenever I use a slicer to manipulate the data it switches the whole graph to one format or another (typically, whichever format I used last) and puts everything back onto one axis. I also noticed that this tends to happen more often if, while filtering, you filter out all the values so that the graph is temporarily blank. Since I have multiple slicers which overlap eachother this happens quite a bit.

Yes, very frustrating! Let me know if you find a solution

 

[JohnOC4U]

I am having the same problem. I found this, but not sure I fully understand his suggested solution, you need to look at the post on the 7 Feb 2013 by Auabde (the last of his posts on that day in the thread).

If you do understand it, perhaps you could explain to me?

Thanks

 

[cardguys3]

I am having the same problem. I found this, but not sure I fully understand his suggested solution, you need to look at the post on the 7 Feb 2013 by Auabde (the last of his posts on that day in the thread).

If you do understand it, perhaps you could explain to me?

Thanks

That link won't solve the problem. From what I read, the user is struggling to adjust the slicer layouts and not the PivotChart Layouts. I can't wrap my mind around this either. I fear that there isn't a way to do this. Perhaps one must chalk this up to an inadequacy, just like making row totals rather than column totals... Alas.