linking spreadsheet colour to chart
 

I have data that I must produce in a chart. Normally from a pivot table. The
certain parts of the data are colour specific from an index. Is there anyway
(other than filling the chart colours in manually) to link the data from the
spreadsheet to the chart?