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?