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?

On Nov 12, 10:27*am, ryan.fitzpatri...@safeway.com wrote:
> 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

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
<(E-Mail Removed)> wrote in message
news:5699a11a-ecc1-43fa-b74b-(E-Mail Removed)...
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?

On Nov 12, 10:27 am, ryan.fitzpatri...@safeway.com wrote:
> 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