Chart axis default scale override

[ken1986]

I have created a line chart with percentages on th Y axis.

There are a couple of anomalies in my data which are 2000% and so the Y axis scale defaults to include these on the chart but makes it impossible to read the other values all of which are under 100%. I have tried setting the maximum as 1 (100%) but the chart defaults back to the original scale to include the 2000%. Is there a way to manually set this so that the Y axis scale never exceeds 100%.

HELP!!

[MFGF]

I have created a line chart with percentages on th Y axis.

There are a couple of anomalies in my data which are 2000% and so the Y axis scale defaults to include these on the chart but makes it impossible to read the other values all of which are under 100%. I have tried setting the maximum as 1 (100%) but the chart defaults back to the original scale to include the 2000%. Is there a way to manually set this so that the Y axis scale never exceeds 100%.

HELP!!

Hi,

You can't set the scale to a value smaller than any of the values your chart needs to display (which makes sense when you think about it). Your options are either to filter out the anomalies so that you are left with values between 0 and 1, or else replace the percentage with a calculation that uses an expression such as:

if ([your percentage item] > 1) then (1.01) else ([your percentage item])

and use this calc in your chart.

Cheers!

MF.