I may have a solution for this. You can set colours of you charts by using this simple VBA macro:
Sub ColorCharts()
For Each ch In ActiveSheet.ChartObjects
For Each ser In ch.Chart.SeriesCollection
s = Split(ser.Formula, ",")
For i = 1 To UBound(ser.Values)
ser.Points(i).Interior.Color = Range(s(2)).Cells(i).Interior.Color
Next i
Next ser
Next ch
End Sub
See my blog post on http://excel4everything.blogspot.fi/...to-colour.html and check the video about this.
Unfortunately this solution doesn't work if you colorise your chart source cells using Excel's Conditional Formatting. Maybe someone can give us a hint how to format cells according to Conditional Formatted cells.
Hope this helps.
Bookmarks