Setting Y axis

  • Thread starter Thread starter Hassan
  • Start date Start date
H

Hassan

Hi All,

I have excel sheet, on Y axis I want to divide into 5 equal interval.
Everytime the data is different. I checked the Maximum in chart. If data is
more then the interval will be 7 or 8 sometimes. How I can do this
automatically.

Thanks
 
Hi Hassan,

I believe that Excel still does not allow you to reference a cell (where the
Max value could be calculated) to help you set the Min, Max or whatever of a
chart. Therefore you would need to use VBA code.

Is code an acceptable solution?
 
Back
Top