Hi, I have two issues regarding the column chart with two series. 1) In case of the following chart, how can I set the vertical axis grid lines by event type, I mean, how can I give a background color to all column that belong to an event (The following chart gives a color between events). 2) It is possible to make the green columns displayed next to each other, red columns next to each other and yellow column next to each other? I mean to group the columns within all events. Please, I need your help regarding this issue. Regards, Bader

Hi Bader, Sorry for the delay. For the first question, it is not supported to set the background color of the chart based on the category group values. To work around it, we can set a background image for the chart. For the second question, you want to place the bars that have the same color next to each other for each instance of a category group. To achieve this requirement, we can set the fill color the bars based on the series group values. Please refer to the following steps: 1. Right click on the series of the chart, and open the "Series Properties" dialog box. 2. Click the "Fill" tab, and set the "Pick Color" based an expression like below: =Switch(Fields!SalesTerritoryCountry.Value="Australia","Tomato", Fields!SalesTerritoryCountry.Value="Canada","Tomato", Fields!SalesTerritoryCountry.Value="France","Lime", Fields!SalesTerritoryCountry.Value="Germany","Lime", Fields!SalesTerritoryCountry.Value="United States","Aqua", Fields!SalesTerritoryCountry.Value="United Kingdom","Aqua") Note: In the expression above, "SalesTerritoryCountry" is the Series group of the chart. The report looks like: Reference: Formatting Series Colors on a Chart Regards, Mike Yin TechNet Subscriber Support If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.Mike Yin TechNet Community Support