Question Access 2007 Multiple Pie Charts how to get consistent color slices

[dltoney2]

I have created a series of pie charts in reports based on queries. The data that is being charted are agree, strongly agree, neither agree nor disagree, disagree, and strongly disagree. I want the colors for these to be consistent in all the pie charts but they are coming out different colors on each chart: i.e., agree may be blue on one pie chart but yellow on another pie chart. How can I change the colors either in the pie charts or legends so that they are consistent on all the pie charts?

 

[DavidAtWork]

I've not tried to manipulate chart objects, bit imagine you'd have set up your source data so that it is consistent in terms of the order in which
"agree, strongly agree, neither agree nor disagree, disagree, and strongly disagree"
values appear, perhaps you can add some sort of sortID to these values and set the sort in your queries.
If you try setting a reference to the Microsoft Graph object library (go to Tools/References in the VB window), then you can use the Intellisense reference to the chart object and manipulate the series colours to make them consistent.

David