Control Y Axis on Pivotchart when using Slicers

**karl_popper** · 10-28-2010, 11:44 PM

I'm creating a PivotChart (line) and PivotTable from a Powerpivot source in Excel 2010. I'm using slicers to create buttons that update the pivottable and pivotchart based on the button selection. The Pivotchart always includes zero on the y axis, which makes many of the lines too flat to see important changes. Individually, I can set the y axis to a fixed min/max, but once a new slicer button is selected, those values will be incorrect for the new chart. How might I update the min/max of the axis to the min/max of the series for any slicer button selected?

**Andy Pope** · 10-29-2010, 05:00 AM

You could try hooking into the pivottable change event.

right click worksheet tab and view code. paste the following.

Please Login or Register  to view this content.

You may need to change the chart object index if you have more than 1 chart object on the sheet.

**mwn00** · 12-05-2012, 10:45 PM

Hi Andy,

I had a similar issue and tried your solution. It seemed to work, but I have multiple pivot tables driving multiple pivot charts on one worksheet. Can you walk me through the steps required to update the 'chart object index'?

Thanks in advance,
Mike

**arlu1201** · 12-06-2012, 02:40 AM

Mike,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.