Setting colours of inverse values

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tim Marsh - 10 Dec 2003 10:12 GMT

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

Reply to this Message

Andy Pope - 10 Dec 2003 11:45 GMT

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.

> as in the title, I have a chart which has values less than
> zero. Positives are coloured green, but negatives are
[quoted text clipped - 3 lines]
>
> Tim

Signature

Cheers
Andy

http://www.andypope.info

Reply to this Message

- 10 Dec 2003 11:54 GMT

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.

>-----Original Message-----
>Hi Tim,
[quoted text clipped - 20 lines]
>>
>> Tim

Reply to this Message

Jon Peltier - 10 Dec 2003 17:50 GMT

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
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

> thanks - i'll give it a go... strange though - you
> would've thought there would be a bit more control over
[quoted text clipped - 44 lines]
>>>
>>>Tim

Reply to this Message