Stacked bar chart

[Former Member]

Hi I hope someone can help me. I have data listing many thousand records over a one month period. I have then grouped these by week and have a summary total for each week. I want to show these on a stacked bar chart as a single column but different colours for the week. At the moment when I select stacked barchart it shows me the total value in a single colour but will not break this down into the weeks with different colours.

I would be grateful for any pointers or examples anyone can give me.

Thanks

Stuart

[Former Member · Accepted solution]

Hi

Right click on chart, go to chart expert. There click on Color Highlight tab, then under simple condition you can add the weeks, probably each week will be highlighted, you can choose different colors for each week you want.

Please try it and let me know any issues.

Regards

Raj Mahesh