Link chart format to a cell

  • Thread starter Thread starter vito
  • Start date Start date
V

vito

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?
 
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?
Click to expand...

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.
 
Thanks for the info. I see if its possible to work this way even if I have to
use more colors.

"Dave Curtis" skrev:
 
Back
Top