consistent coloring of bar charts (v10)

[Kevinski]

I have a report which produces a dozen bar charts which show how many service calls have been allocated to a group of people and individuals within that group.

I have categorised the due date of the service calls as 'Today' 'Tomorrow' and 'Overdue' via a formula.

How can I get consistent coloring of these groupings across all bar charts?

For example so 'Today' is always green, 'Overdue' is always red and 'Tomorrow' orange.

I have a formula which calculates the due date and have used the highlight expert for that but it doesn't affect the charts so on one chart currently the overdues are green, on the next they're red etc

 

[huggyd]

I am using CR10 and you have the chart color option in the Chart Expert dialog box, on the Options tab. If you click the Format button you will then have the ability to select field,value and color combination required.

Unfortunately you'll have to do this for each chart in your report but it will keep them consistent