Del, thank you for your response and lots of useful suggestions. Actually I
did come across a solution that was helpful, which i am happy to pass on.

Double click the 0 line (ie the Category axis) and that opens the Format
Axis box. Under "tick mark labels" select "low". This was perfect for my
given problem. Again, I appreciate your support. Cheers. Trish

"Del Cotter" wrote:

On Wed, 28 Nov 2007, in microsoft.public.excel.charting,
Del Cotter said:

1) abandon the positive/negative display and just go for a stacked
column chart with the Rec and Prob adding up to "Response". This was my
first idea, but I admit Jon's looks better (no problem with being able
to compare bars that don't line up). This way means you can just use X
axis labels.

Oh, there's another couple of options I forgot!

1.5a) format the Y axis scale so that the X axis crosses it at "-9999",
i.e. at the bottom of the chart.

1.5b) format the X axis so that, although it crosses the Y axis at zero,
the tick mark *labels* are "Low" instead of "Next to axis"

I've been assuming it's the category labels you're talking about, and
not the value of the numbers. The numbers are so small I think you
should trust people to use their eyes instead of showing the numerals,
or choose a table instead if you really prefer the integers, or use
Autoshape pictures to turn the stacked columns into countable stacked
shapes if you prefer graphics but want people to see the integers.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.