Setting colours of inverse values

  • Thread starter Thread starter Tim Marsh
  • Start date Start date
T

Tim Marsh

as in the title, I have a chart which has values less than
zero. Positives are coloured green, but negatives are
white and i want to make them red.

all help greatly received - thanks.

Tim
 
Hi Tim,

My quick play of Invert if negative didn't produce the effect described
by the help file.
"Reverse the Foreground and Background colours"
It simple made the negative columns white.

I think the best approach would be to create 2 set of data based on your
original. One for positive values on for negative. Both these series can
be formatted as required. Use NA() for a point that is not required.
So for your original data in A1 the formula for B1 and C1 would be;
B1: =IF(A1>=0,A1,NA())
C1: =IF(A1<0,A1,NA())

Use a stacked chart or a cluster with the overlap set to 100.




Tim said:
as in the title, I have a chart which has values less than
zero. Positives are coloured green, but negatives are
white and i want to make them red.

all help greatly received - thanks.

Tim
Click to expand...

--

Cheers
Andy

http://www.andypope.info
 
thanks - i'll give it a go... strange though - you
would've thought there would be a bit more control over
what you can display.
 
The reason you saw white is that white is the default background color.
And without setting an actual pattern, you can't change the background.

Double click your series, click on the Patterns tab, click the Fill
Effects button under the fill color choices, then click the Patterns
tab. Select Foreground and Background colors, then pick the 90% pattern
(bottom of second column). You see the occasional dot of the background
color on the sea of the foreground color, but it's the best you're going
to get. Click okay until you come back to the panel where you can check
the Invert if Negative box, and check it. The fill will now invert
between 90/10 and 10/90.

Andy has described the technique behind my Conditional Chart example:
http://www.geocities.com/jonpeltier/Excel/Charts/format.html#CondChart

- Jon
 
Back
Top