Format y Axis and auto check

[oklogin]

Excel users,
I'm having problem with my EXCEL financial charts ant the formating of the Y axis.

When the auto box is checked for the auto Minimum value I don't want the value to be 0 but to be the best higher number. Is there someway with out taking out the check and having to put in a manual number (takes too much time because my values keep changing) for this to happen ? Sometimes it will not go to 0 but usually does. I see no where to make this change. Any help on this would be most appreciated......
Dennis Rans
Seattle, WA

 

[Alan2005]

Hi,

Well this can be done. I would suggest you turn on the macro recorder and change some values for this/these fields.

This will give you the syntax to apply the value of your choice.
This could be a specific variable or cell value.

I hope this points you in the right direction.