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