View Single Post
  #1  
Old June 5th, 2010, 11:58 AM posted to microsoft.public.excel.misc
ann
external usenet poster
 
Posts: 462
Default Excel chart - great variation in values

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?