who do i conditionally change bar chart colors?

#1 09-12-2005, 06:05 PM

I want to change colors of the bars in a chart based on conditions. So if
there is a negative number, i want one color. If the number is +ve, i want
another color. This is similar to conditionally formatting of cells, except
for bars.

#2 09-12-2005, 11:05 PM

You need several series to do this. Have one series for negative numbers,
and another for positive numbers. Just make sure you include ZERO in your
calculations.

"Sid N" <SidN@discussions.microsoft.com> wrote in message
news:13AA9C83-1E89-44F1-BB93-BB1DFAC9F0AC@microsoft.com...
>I want to change colors of the bars in a chart based on conditions. So if
> there is a negative number, i want one color. If the number is +ve, i want
> another color. This is similar to conditionally formatting of cells,
> except
> for bars.

#3 09-13-2005, 04:05 PM

Here's an illustrated example:

http://peltiertech.com/Excel/Charts/...nalChart1.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Barb Reinhardt wrote:
> You need several series to do this. Have one series for negative numbers,
> and another for positive numbers. Just make sure you include ZERO in your
> calculations.
>
>
> "Sid N" <SidN@discussions.microsoft.com> wrote in message
> news:13AA9C83-1E89-44F1-BB93-BB1DFAC9F0AC@microsoft.com...
>
>>I want to change colors of the bars in a chart based on conditions. So if
>>there is a negative number, i want one color. If the number is +ve, i want
>>another color. This is similar to conditionally formatting of cells,
>>except
>>for bars.
>
>
>

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)