I have an example of a chart in an Excel 2003 spreadsheet where the colors for the legends and slices must be looked up from another column.
I want the attached example file ([url removed, login to view] - it will have to saved as .xls to allow for VBA functions) to have the slices ('Business Name') and the legend of the pie chart coloured by their 'Current Rating' values. The colors for the 'Rating' can be looked up in the background colors of the cells in the 'Rating' column. I also want the chart to recognise any patterns set on the 'Rating' cells.
Each slice of the pie chart should be equal in size. The color and pattern of each slice should be based on the 'Current Rating'. The colors and patterns are picked up from the 'Rating' column cell formats. The legend must also show the colors and patterns. The spreadsheet must be compatible with Excel 2003.