Dynamically Formatting Chart Colours

[DiggerDog]

Hi
I'm using Crystal Reports 10 and need to dynamically format the bars in a chart. I have created a 'team' group in the report and have place a chart in the group header. I need to change the colour of the chart depending on team name.

So If the first instance of the group is 'Red Team' I want the chart bars coloured red, if the next instance is 'Green Team' I wnat the chart bars coloured green, and so on.

Does anybody know if this is possible or do all instances of the chart have to have the same colour bars. (I tried manually changing the colours but these reset every time I refresh the report)

Thanks

 

[Dan3D]

I believe there is a section in the ChartExpert where you can format a colour based on field and expression (I.e. "If field == RED, color = RED").

Dan Weingart
OEM Technical Manager
Three D Graphics, Inc.

http://www.threedgraphics.com