Changing bar graph colours based on score peercentages

Hi there

I have a whole heap of data for my students, that I am gathering from their assessment results. I have created a chart that shows their results as a percentage. What I want is to show results over 80% as blue, exactly 80% as green and below 80% as red.

Seeing though I am a VBA numpty, I was wondering if there is someone who knows how to do this.

Thankyou in advance

Matt

Hi Andy

Thanks for that. Have already seen that one actually. I think I need to explain further.

The graph that has the student results is being feed from a table which is being updated from an Input Form (excel). Therefore the cells that have the data already have lookup formulas in them, so I am not sure how to incorporate the formlas required for the chart colouring (as per you link) with the formulas I already have in the cells.

Hi Andy
Sorry can't actually send you the files, there are a number of workbooks, all interacting, without one the others wont update thus sed data to the graphs.

Matt

Hi Andy

I have created a dummy. Its a cut down version of what I am working on but the principle is the same. A graph is being feed from a small table which is indexing from a nother table. The graph data changes when you change the cell B30 from 1 to 4 to access the different assessments.

The bars in the graph need to change colour based on the percentage.

Hope this helps a bit more, to show what I am attempting

Thanks

Matt

Andy

Thankyou so much, you're a champion. I do have another problem, but will save it for another day.

Matt

Silly question now.

How do I change the colours. Where are they being referenced from?

I now understand.

Thanks again