A question, is it possible to have the bars on graph the same color as highlighted cell.

[baggypants]

Hi All,

I have data which is conditional formatted in the range based on its progress.
If completed, cell turns green. If in wip, the cell is amber, incomplete red.
when I run a pivot table and chart it sure would be handy if the colors in the graph reflected the state as the data shows. Some cells change daily so filling manually would be a pain. (x axis is in hours)

Is it possible to do this? It would be really neat.

Thanks in advance for looking in and giving me some guidance.

[LokeshKumar]

Hi,

It can be done through VBA..but it would be too complex..
It will change the chart color as per the cell.

[humdingaling]

yes VBA can do it
how complex would depends how complex your chart is
perhaps a sample data/chart

[humdingaling]

actually i remember doing something like this before

see this thread
http://www.excelforum.com/excel-prog...ormatting.html

For a non VBA solution...you need to manipulate the data going into the chart
http://peltiertech.com/tag/conditional-chart/

[baggypants]

Wow, great examples. Thank you for the reference humdingaling. I will play around with this on the weekend and see if I can do something similar. Great references.

Thank-you very much.

[LokeshKumar]

Please Click STAR to Add Reputation if my/someone's answer helped!
Mark this thread as solved.