Conditional formatting a bar chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello.

I feel that I am so close, I can taste it! I have looked at a number of
postings here and tried some of the referenced websites but just haven't been
able to get this to work. Any help would be appreciated. My problem is:

I have a bar chart tracking stock performance. For each stock, I have a cost
basis and a current value which is either greater or less than (or possibly
equal to I suppose) the cost. What I want to do is to create a bar chart that
when the current value is less than the cost, the difference between the
current value and the cost is shaded red. When the current value is greater
than the cost, the difference is shaded green. I have tried using the overlap
but I cannot then figure out how to fill in the colours or use the
move-to-back or move-to-front (if I can even do that). Should I use stacked
columns instead?

Help!!!

Thanks,
CKD
 
Thanks Jon.

After spending most of last night plugging away using your waterfall charts
as a base, I finally go it to work. I didn't fully appreciate what you can
get charting to do for you until I looked at your site.

Thanks!
 
Back
Top