Hi,
I have an thermometer chart and at the moment it is colour red. On my spread sheet I have a RAG status - Red/Amber/Green
Is there anyway in which I can colour the lines based on a cell (if it contains "Red", "Yellow" or "Green")?
e.g. on the attached the surrounding bars are black - I would like this red, yellow or green.
Bookmarks