Setting Y axis
 

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

Setting Y axis
 

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?
--
Thanks,
Shane Devenshire


"Hassan" wrote:

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