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

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