I have graph which shows values from A1 to C3. I just change data in cells,
so graph changes with values in those cells.
I would like that values on y axis (ordinate) starts from 0 (zero) and not
from some number. How to solve this through VBA?

Thanks in advance

"Marc" wrote in message
...
I have graph which shows values from A1 to C3. I just change data in cells,
so graph changes with values in those cells.
I would like that values on y axis (ordinate) starts from 0 (zero) and not
from some number. How to solve this through VBA?

Hi Marc,

Assuming this is the only chart located on the active worksheet, the VBA
required to do this would be the following:

ActiveSheet.ChartObjects(1).Chart _
.Axes(xlValue).MinimumScale = 0

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm