Stacked Columns Groups Help

[SamuelT]

Hi all,

I've been asked to create a chart and am having some problems sorting it out, hope someone might be able to help.

I have a set of data (see attached doc) which has actual and potential figures. What I'm trying to do is for each month, display the actual and potential figures in a stacked chart. The problem is, however, is that my colleague wants each Potential and Actual figure to be in their own stacked chart.

Hence, for January, you would have a column with Potential Nov and Actual Nov displayed, then another with Potential Dec and Actual Dec displayed, and one other with Potential Jan and Actual Jan. The same would be done for February, March, etc. The final chart would therefore have three columns per month.

I hope that makes sense. Any advice welcomed!

TIA,

SamuelT

[Andy Pope]

You will find more info here on create clustered stacked column charts
http://peltiertech.com/WordPress/200...column-charts/

[SamuelT]

Thanks Andy - that looks like what I'm after.

SamuelT