Is it possible to control which colors are displayed where in a pie chart on a report? For example if I do a report on survey data, there are 4 slices to a pie chart, happy, exceeded expectations, not happy, and unacceptable (for example). Can you force the 'unacceptable' slice to be red, the Happy to be Green, the Exceeded to be Gold, the not happy to be orange? I see where you can specify the colors to be used, but it doesn't assign a specific color to a specific data element in the report.
Thoughts appreciated,
Edward
