Use macro to change slice color on multiple charts

[Whiskjack]

Hi there.

I don't have much experience with Excel, but I've been trying to find a way to automate a tedious/time consuming task.

I currently have 9 donut charts each representing a clock. I have each chart broken down into 24 slices to indicate hours per day. I'd need to keep these slices at a fixed size. Each hour of those clocks is coloured based on a value in the table. I'd like to use a macro to change the colour of each slice depending on the value.

I tried my hand at a macro but I was doing one slice per clock at a time, meaning there would be a very large macro for what looks like a simple requirement . (IF RANGE("C3") = 0 THEN ...color white... ELSEIF RANGE("C3") = 1 THEN ... color red ..., just a complicated mess by the end) I hope there's a much more efficient way to do it, and allow for the addition or removal of charts.

Am I overcomplicating this? Is there something I can read up on that might steer me in the right direction?


Here's what I'd like it to look like:

http://i.imgur.com/UPanvTG.png

I appreciate any help!

 

[Whiskjack]

Is this not possible or have I just explained myself poorly?