Hi
I have a pivot chart that's based on data that only goes up to 100%
The data has categories with price compliance figures of 43%, 75%, 94%, 100%, etc.
However, although the maximum price compliance figure is 100%, the vertical axis on the Pivot Chart goes up to 120%!!
Do you know how I can alter the chart, so it only goes up to 100%?
I have a pivot chart that's based on data that only goes up to 100%
The data has categories with price compliance figures of 43%, 75%, 94%, 100%, etc.
However, although the maximum price compliance figure is 100%, the vertical axis on the Pivot Chart goes up to 120%!!
Do you know how I can alter the chart, so it only goes up to 100%?
