I have a slight problem that Im most likely overlooking the solution to:

 

I have a stacked bar graph report that I made up that I need to refresh with a new data selection per report (the graph data selections stay the same, but the data itself changed based on the asset I place in the select expert). But, every time I add the different selection and refresh, the colors for each of the series does the ol' switcharoo. Instead of manually changin the color to stay consistent accross all of my reports, is there a way to assign each series a specific color that will remain the same after refresh? If I leave it to change on every chart...that will get rather confusing to the viewer.

 

Thanks!

 

p.s. im runing Crystal 10 if that makes a difference