How to create a graph based on a cell colour.

I need to create a graph based on a cell colour. The spreadsheet is used to control budgets by using a traffic light system to determine what has been spent (or definitely will be spent), what may be spent, or what budgeted cost have yet to be spent (or planned to be spent). These will be coloured green, amber, red respectively.

The chart will be split monthly with each bar split green, amber, red, accordingly.

I would appreciate any help at all with this problem.

You color that cells manually?

Yes, cells are coloured manually.

Thanks