Setting Y axis

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hassan - 20 May 2008 11:38 GMT

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

Reply to this Message

ShaneDevenshire - 20 May 2008 16:15 GMT

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?

Signature

Thanks,
Shane Devenshire

> Hi All,
>
[quoted text clipped - 4 lines]
>
> Thanks

Reply to this Message