View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Del Cotter Del Cotter is offline
external usenet poster
 
Posts: 560
Default Link chart format to a cell

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.