Mickey,

Yes, you can. You will need to set up a dummy X axis series to do so.

Assume you start with the following data for your XY chart:

x y
1 4
3 3
2 4
3 5
4 4
5 5

Now assume that you want the X axis to cross the Y axis at 3. Add a second
series consisting of the following data points below. The purpose of this
series is to act as a dummy X axis.

x y
0 3
1 3
3 3
2 3
3 3
4 3
5 3
6 3

In the Format Data Series dialog box, make sure that the second series is
set to automatic or custom €“ you want it to look like a line. Also in the
Format Data Series dialog box, go to the Data Labels tab and check the X
value option. You can now individually select the data label for zero on the
second series and delete it. Next, delete the reference to the second series
in the legend. Finally, delete the chart generated X axis labels by
double-clicking on them. In the Format Axis dialog box, go to the Patterns
tab and set the tick mark labels = None and the major tick mark type = None.

--
Regards,
John Mansfield
http://www.pdbook.com


"mickey huson" wrote:

When an x-y chart is formatted so that the x-axis intersect the y-axis in the
middle, the first number on the x-axis appears on top of the y-axis. Is it
possible to remove this first number label?