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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How I can set dynamic pivot table ONLY when I have enough data point 1
Two-tone color column chart 2
Changing chart colours using VBA 2
Can't format 'invert if negative' colour programmitically (macroignores it!) 0
Chart rotation 3
How to Hilight Chart's Source Data? 4
Help: Chart & data 1
Paste Excel Chart into Existing Powerpoint Chart 1

Back
Top