chart help

  • Thread starter Thread starter ryan.fitzpatrick3
  • Start date Start date
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
 
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?
 
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?
 
Back
Top