joeu2004 -

For a "manual" solution: Select the X axis. Choose Format Axis | Scale |
Value (Y) Axis Crosses At.

For an "always" solution, I think you need VBA.

- Mike

www.mikemiddleton.com

wrote in message
oups.com...
In an XY Scatter chart, if X has negative and positive
values, the Y-axis values are next to the Y-axis, which
of course is drawn through X = 0.
I would like the Y-axis values to always be on the left
side of the chart.
How can I make that happen?