Crystal Reports Defining bar colour in stacked bar chart

Message

     I have considered a gantt but there are two  issues for me.

1. Since the elements would be displaced sideways I would be able to diplay a full month on one page. I operate the chart in horizontal mode and can display 31 days beautifully.
2. I am trying to match visually the display of similar data from a different package so that the client will be able to compare.

I find it strange that it is not possible to change the colour  based on data in another field or table since it would be very useful in many situations.
Strangly you can modify the chart border & background based on formula and other data. In my mind a rarely required function.

I think I will add this feature to the future updates section.

thanks for the help, if you think of a solution please post it.

merlot 