View Single Post
  #1   Report Post  
 
Posts: n/a
Default Can tick mark labels be flipped about axis?

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.