Bar Chart with trend analysis

[anar_baku]

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.

[Andy Pope]

Here is one of many previous posts, search for Stacked+Cluster

http://www.excelforum.com/excel-2007...el-2007-a.html

[anar_baku]

Thanks a lot Andy. I also found this useful:

http://blog.contextures.com/archives...stacked-chart/