Create a matching color for crosstab and chart

[captphan]

I have a bar graph that is showing the same data as a cross tab. I want to format the rows in the cross tab to be the same as the colors in the bar graph. How can I make this happen?

 

[lbass]

I think you could only do this manually, by selecting crosstab cells and using the following in format field->border->color->background->x+2:

select gridrowcolumnvalue("table.row")
case "A" : crRed
case "B" : crBlue
case "C" : crAqua
default : defaultattribute

-LB

 

[captphan]

I am sorry I am kind of new to Crystal. Where would i Put this? Also Is there a place I can put the same code in the bar graph to insure consitentcy between the two?

 

[lbass]

I think you have to manually select the colors or accept the default colors, and then match the crosstab colors. For the crosstab colors, select the appropriate cells->format field->border->color->background->x+2 and enter the formula there (which I already explained).

-LB

 

[captphan]

I got it now. Thank You