I want to create a chart that changes format depending on value in a special
cell.
For exemple a bar chart that for one value have blue bars (the whole chart)
and for another value red bars?
Please anyone?

On Thu, 26 Jun 2008, in microsoft.public.excel.charting,
vito said:
I want to create a chart that changes format depending on value in a special
For exemple a bar chart that for one value have blue bars (the whole chart)
and for another value red bars?

You can't, it's not possible in Excel. But you can have two series, one
which is always zero, except when the other one is zero. Then it looks
exactly like a bar that changed color.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

Hi,

Suppose your data series is in A2:A11. Enter the word red in A1. Create
another data series next to it using, for instance, in B2,

=IF($A$1="red",B2,NA())

and copy down.

Add both series to a column/bar chart, format one red and the other blue,
and set the overlap to 100%.

Then depending whether or not A1 contains the word "red", the chart will be
either red or blue.

You can tart it up a little with a checkbox, radio button, drop down list
etc to toggle the contents in A1.

Hope this helps.

Dave

url:http://www.ureader.com/msg/10296299.aspx

Thanks for the info. I see if its possible to work this way even if I have to
use more colors.

"Dave Curtis" skrev:

Hi,

Suppose your data series is in A2:A11. Enter the word red in A1. Create
another data series next to it using, for instance, in B2,

=IF($A$1="red",B2,NA())

and copy down.

Add both series to a column/bar chart, format one red and the other blue,
and set the overlap to 100%.

Then depending whether or not A1 contains the word "red", the chart will be
either red or blue.

You can tart it up a little with a checkbox, radio button, drop down list
etc to toggle the contents in A1.

Hope this helps.

Dave

url:http://www.ureader.com/msg/10296299.aspx