Format y Axis and auto check

oklogin

New Member
Joined
Dec 29, 2005
Messages
1
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
 

Some videos you may like

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

Alan2005

New Member
Joined
Oct 12, 2005
Messages
22
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,536
Messages
5,572,767
Members
412,482
Latest member
arooshrana2
Top