Highlight in bar chart?

[dswitzer]

CR XI - SQL Server 2000.

I have a dataset like:

cat catflag ct
5 0 10
6 0 12
7 1 8
8 0 15
9 0 20

I want to create a bar chart in crystal where the bar with the flag set to 1 is a different color than the other bars. Is this possible? It seems that there are so many options in Crystal that you can modify with a formula - but not this one?

Thanks.

 

[dswitzer]

Got it. Maybe this will help someone else...

Set up the data differently. Get the data so it looks like this:

cat catflag series1 series2
5 0 10 0
6 0 12 0
7 1 0 8
8 0 15 0
9 0 20 0

Notice how the column I want a different color (where catFlag=1) has a zero value in series1, and the value is in series 2. catFlag is meaningless here other than to show you which one should be highlighted.

Then, instead of creating a bar chart -- create a stacked bar chart where series1 is colored the base color and series2 is colored the highlight color...simple workaround - but it works! I wish I could give myself a star for this one!