chart help

R

ryan.fitzpatrick3

In a chart when I create a column chart. If I click on a data point
and click inverted if negative how can I program that the columns will
be red instead of white?

ryan
 
R

ryan.fitzpatrick3

Also is there away to change the axis value colors, if I have 0 in the
middle of the chart and positive numbers on top and negative on
bottom, is there away to make the positive green while the negative
red?
 
A

Andy Pope

Hi,

Axis scale colour can be done with a custom number format,
[Green]General;[Red]-General;General

Controlling the Invert if negative formatting can be done using this
technique in xl2003 or before.
http://www.andypope.info/charts/Invertneg.htm

For xl2007 you will need to use a conditional charting technique of creating
2 series, one for the positive values and one for the negative values.
Set the series Overlap property value to 100%

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
Also is there away to change the axis value colors, if I have 0 in the
middle of the chart and positive numbers on top and negative on
bottom, is there away to make the positive green while the negative
red?
 
Top