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.