Hi,

I'm plotting a number of XY scatter charts with negative and positive
numbers on both axes. These axes must intersect at their zero points
and I need to display tick mark labels next to both. However, I find
that these labels tend to obscure each other at the intersection. Is
there a way of removing some of them near the intersection, for example
by selectively setting the font color to transparent? Alternatively,
can the labels be 'flipped' about their axis like the high/low setting,
but having them still next to the axis insead of at the top or bottom
of the chart? I tried the XY Chart Labeler add-in, but this merely adds
labels that follow my plotted curve and this is not what I want. For
example, pictorially, I want something like this (and maybe similarly
for the y-axis):

2| 2|
| |
1| 1|
| |
| -2 -1 0| 1 2
------------------ ==> ------------------
-2 -1 0| 1 2 |
-1| -1|
| |
-2| -2|

Thanks in advance.
John.

Hi,

I think the xy chart labeler is the way to go but you need to add some
extra data series that travel along the axis. Then the labels can be
applied to that rather than your actual data.

Cheers
Andy

(E-Mail Removed) wrote:
> Hi,
>
> I'm plotting a number of XY scatter charts with negative and positive
> numbers on both axes. These axes must intersect at their zero points
> and I need to display tick mark labels next to both. However, I find
> that these labels tend to obscure each other at the intersection. Is
> there a way of removing some of them near the intersection, for example
> by selectively setting the font color to transparent? Alternatively,
> can the labels be 'flipped' about their axis like the high/low setting,
> but having them still next to the axis insead of at the top or bottom
> of the chart? I tried the XY Chart Labeler add-in, but this merely adds
> labels that follow my plotted curve and this is not what I want. For
> example, pictorially, I want something like this (and maybe similarly
> for the y-axis):
>
> 2| 2|
> | |
> 1| 1|
> | |
> | -2 -1 0| 1 2
> ------------------ ==> ------------------
> -2 -1 0| 1 2 |
> -1| -1|
> | |
> -2| -2|
>
> Thanks in advance.
> John.
>

--

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