Excel 2003 Column Chart

[Sandy]

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

 

[Andy Pope]

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

 

[Del Cotter]

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

 

[Sandy]

Thanks Andy - Interesting Site!
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