Hi all,

I'm trying to create a stacked Bar Chart with trend analysis.

So here is the background:

I have 3 measures, let's say Revenue, Profit and Cost (hence 3 bars). Then I have 3 components for each, let's say Region 1, Region 2 and Region 3 (these are the stacks). So end result: 3 bars, each with 3 stacks. So far so good.

Now the problem:
Let's say all the above data relates to Year 1, but I want to show Year 2 as well. So instead of 3 bars with 3 stacks, I want 6 bars (2 for each of the 3 measures). If I select all the data Excel will by default just create 3 bars with 6 stacks which is not what I'm after!

I tried to tweak with series, but no joy. (I'm using Excel 2007).

Please help.