Hi, I have a range chart with multiple bars and each bar corresponds to exactly one data record. I'd like to colour the bars depending on another field in the dataset and display a colour legend. A series group seems right for this but if I create a series group based on the common field, the bars get very thin as if it's expecting to display data for all the possible values of the series group... This is the layout I want ... And this is what happens if I add a series group to get the colouring I'd like... Any ideas how I can get the colouring but without all the empty spaces?

Hi Edmund, In your case, I think that you can customize the range bar colors by writing an expression for the Color property. Please refer to the following example as a reference: 1. Click the range bars in the chart. 2. Use the following expression to set the Color property: =Switch(Fields!CategoryGroupField.Value=A,Red, Fields! CategoryGroupField.Value=B,Yellow, Fields! CategoryGroupField.Value=C,Blue) (Note: Please modify the expression based on your environment) If you have any more questions, please feel free to let me know. Regards, Bin Long TechNet Subscriber Support If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here. Bin Long TechNet Community Support

Hi Bin, Thanks for the reply - unfortunately I can't necessarily predict what the CatergoryGroupField.Value will be in advance so I'd prefer to let SSRS handle the colouring and create the legend - is there any alternative way to get SSRS to colour the bars without creating the blank spaces? Or to get the Category/SeriesGroup not to graph the empty rows? Regards, Edmund