Removal of number label from x-axis
 

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?

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?

Hi,

How about a custom number format on the x axis.
[Black][0]General

The value may need adjusting depending on your data values.

Cheers
Andy

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?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

if you want to hide all of the data labels double click on the axis select
patterns and select none for Tick mark lables.
You can also select the tick mark labels to show high or low to get them out
of the graph area.

If you just don't want a number on top of the y axis. set your scale
parameters such that one of the displayed numbers is not at 0

If none of these are what you want there are other more coomplicated ways to
do format Apparent axis data (Not all of them are really axis data)

"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?