Page 1 of 1

Pivot Table Axis Values

Posted: Thu Jun 29, 2017 8:10 pm
by DOverbury
Hi

I have been creating a Pivot table with a slicer.

The values I'm shown have a large range so when I'm showing all the data I need a large axis range, however when I'm filtering the results with the slicer the axis is staying at the same values, is there a way to scale this through the slicer?

Hope this makes sense

Cheers
DCO