Dynamic Axis Bounds - is it possible?

[rgunter]

I have some pivot charts connected with a slicer. The chart looks good, but when I use the slicer to narrow down the data, the bounds stay the same so some options have all the bars/lines squished together. Is there any way to change the bounds when using the slicer so that the end user does not have to do anything other than select their option in the slicer?

Just to clarify I'm talking about the minimum and maximum bounds on the left axis.

Thanks,

[dflak]

Pivot charts are a different kind of animal than regular charts. They are great in that they are "quick and dirty" but they have some limitations.

You may have better luck overlaying the pivot table results with named dynamic ranges and use the names to to run the charts. I can't say more than that without seeing a sample file.