Bar graph colour changes

[Guest]

I have an excel pareto bar graph. The values are linked to another workbook &
will change daily. I want different values to be different colours by
selected group, i.e. top value may be yellow, next 2 values red, but next day
the top value (yellow) may now be 2nd value but needs to stay yellow. This
can be done manually each day, but I wonder can it be done automatically by
adding another value to the source data. 1=yellow, 2=red etc.
Any help will be gratefully appreciated

 

[Andy Pope]

Hi,

Have a look at Jon's page(s) on conditional charts.
http://peltiertech.com/Excel/Charts/ConditionalChart1.html

VBA maybe another approach you could use.

Cheers
Andy

 

[Guest]

Thanks for the idea, I may have to try VBA as the data that will control each
colour won't be appearing as part of the graph.