Setting Y axis

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
 
S

ShaneDevenshire

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Two sets of intervals on Y axis 3
Changing the Y axis on a column chart 1
Coordinate secondary y axis to primary y axis 2
y axis 1
Make Y-axis values correspond to x- axis value 1
Horizontal Axis Options Changing 6
How do I put words as the Y axis values? 0
Trying to color every other X axis interval... 6

Top