Is there anyway to have a column chart show negative numbers above the
category axis rather than below?
and at the same time when the number is negative to have the column coloured
(say) Red to Black?
(A bit like conditional formatting I suppose)
Sandy

Hi,

Here is an explanation of how to set the colours used in negative values.
http://www.andypope.info/charts/Invertneg.htm

The category labels are best positioned out side the plot area in order
to avoid clashing with the columns.

Cheers
Andy

Sandy wrote:
Is there anyway to have a column chart show negative numbers above the
category axis rather than below?
and at the same time when the number is negative to have the column coloured
(say) Red to Black?
(A bit like conditional formatting I suppose)
Sandy

On Sun, 3 Jun 2007, in microsoft.public.excel.charting,
Andy Pope said:
Here is an explanation of how to set the colours used in negative values.
http://www.andypope.info/charts/Invertneg.htm

The category labels are best positioned out side the plot area in order
to avoid clashing with the columns.

But if you must do it your way, Andy is happy to show you how :-)

http://www.andypope.info/charts/posnegdlabels.htm

--
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.

Thanks Andy - Interesting Site!
Sandy

"Andy Pope" wrote in message
...
Hi,

Here is an explanation of how to set the colours used in negative values.
http://www.andypope.info/charts/Invertneg.htm

The category labels are best positioned out side the plot area in order to
avoid clashing with the columns.

Cheers
Andy

Sandy wrote:
Is there anyway to have a column chart show negative numbers above the
category axis rather than below?
and at the same time when the number is negative to have the column
coloured (say) Red to Black?
(A bit like conditional formatting I suppose)
Sandy