Excel chart - great variation in values

[Ann]

I am trying to create a column or line chart where a value for 9 variables
are given for each month of the year. My problem is that the values are
mostly between 0 and 40. I have one value though that is 280 and this makes
the chart not really legible.
Is there any way to have the scale on the y-axis showing 5 as major unit up
until 50 and after that 50 or 100?

 

[Lars-Åke Aspelin]

I am trying to create a column or line chart where a value for 9 variables
are given for each month of the year. My problem is that the values are
mostly between 0 and 40. I have one value though that is 280 and this makes
the chart not really legible.
Is there any way to have the scale on the y-axis showing 5 as major unit up
until 50 and after that 50 or 100?

I don't think so.
But here are two other possibilities that you can try.

1) Use a logarithmic scale

2) If the high values are always for the same variable (or variables),
use a secondary y-asis for this/these variable(s)

Hope this helps / Lars-Åke