Associate
- Joined
- 23 Apr 2007
- Posts
- 1,785
- Location
- Cardiff-ish, Wales
Hi guys,
I'm putting together a simple RAG chart ie Red, Amber, Green against 15 categories. I'm trying to get an average colour of all the categories e.g. if I had 13 Red, 1 Amber and 1 Green then Red would be the average colour. It's not necessarily the colour that has the most occurances though, e.g. 5 Red, 4 Amber and 6 Green wouldn't be a Green average, it's probably Amber.
Am I making sense? What's the best way of trying to work this out?
I'm putting together a simple RAG chart ie Red, Amber, Green against 15 categories. I'm trying to get an average colour of all the categories e.g. if I had 13 Red, 1 Amber and 1 Green then Red would be the average colour. It's not necessarily the colour that has the most occurances though, e.g. 5 Red, 4 Amber and 6 Green wouldn't be a Green average, it's probably Amber.
Am I making sense? What's the best way of trying to work this out?