Excel VBA Charting at Axes("xlValue")
 

1. Enter an Excel Chart Sheet via VBA and plot a chart thereof.

2. Have attempted to locate the y-axis by giving,
ActiveChart.Axes("xlValue").Left

3. But, needless to say, it has not worked well.

4. Nevertheless, what else would be a viable alternative to return the
position of Axes("xlValue") ?

5. Please share your experience.

6. Regards.

Excel VBA Charting at Axes("xlValue")
 

Try:
ActiveChart.Axes(xlValue).Left

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


wrote in message
oups.com...
1. Enter an Excel Chart Sheet via VBA and plot a chart thereof.

2. Have attempted to locate the y-axis by giving,
ActiveChart.Axes("xlValue").Left

3. But, needless to say, it has not worked well.

4. Nevertheless, what else would be a viable alternative to return the
position of Axes("xlValue") ?

5. Please share your experience.

6. Regards.

Excel VBA Charting at Axes("xlValue")
 

Mr. Jon Peltier, Microsoft Excel MVP

Thank you very much indeed and still, thank you again.

Regards.