Morning, I have a list of 35 shops and their sales, the chart updates weekly and the list of shops re-orders according to their sales position
The ordering of the shops is based on a formula, using the LARGE function
Some of the shops need to have their data point in a different colour.
Up...