Conditional formatting a bar chart
 

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

Use two series, not one. One series is for good, the other for bad, each
formatted accordingly. Se this page for details:

http://peltiertech.com/Excel/Charts/...nalChart1.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Caro-Kann Defence wrote:

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!

"Jon Peltier" wrote:

Use two series, not one. One series is for good, the other for bad, each
formatted accordingly. Se this page for details:

http://peltiertech.com/Excel/Charts/...nalChart1.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Caro-Kann Defence wrote:

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