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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Chart Formatting 1
How to create a bubble chart with more than 2 variables 0
Word On a bar chart I want to have just one horizontal line, crossing the y axis at a value I determine. 1
One extra x axis item that wont go away - can anyone help? 3
Inside Base Series Label Showing #N/A 0
Charts within a cell 1
Conditional Formatting of Bar Charts 2
Excel Changing chart label colors based on a value in a cell 0

Back
Top