Automatic minimum value on y-axis

[Roger]

I have a simple series of graphs showing date on the x-axis and a
monetary value on the y-axis. The y values vary from 1000 to 2000
sometime or 1000000 to 1100000 other times. I want the y-axis to
re-size depending on the smallest and biggest values being graphed.

I don't want the y-axis scale to start at zero but every time I tick
the auto box next to minimum then it defaults to zero.

I could write VBA to determine the minimum but this seems contrary to
what the auto bit is meant to do? The auto max buit works fine.

I'm using Excel 2000.

Any suggestions?

 

[Frank Kabel]

Hi Roger
have a look at the following site (VBA is not required for this, you
can link the axis values to a cell in your spreadsheet)
http://peltiertech.com/Excel/Charts/AxisScaleLinkToSheet.html

HTH
Frank

 

[Jon Peltier]

Frank -

Actually, you DO need VBA. You can't link the axis values to the sheet,
you have to rely on VBA noticing that the cells change, then applying
the new cell values to the axis.

The way the automatic axis scaling works in Excel is that, if the
minimum value of Y is less than some arbitrarily high fraction of the
maximum (something like 5/6), the axis defaults to a minimum of 0. A bit
aggravating if you like the scale expanded to spread out the data.

- Jon

 

[Frank Kabel]

Hi John
you're right, Messes this up with dynamic ranges. Thanks for pinting
this out
Frank
P.S: also thanks for your excellent site (has saved me hours!)

 

[Tushar Mehta]

As has been pointed out, you have to use VBA. For a readymade
solution, check the AutoChart Manager add-in, available from my web
site.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions