Stacked columns in charts - can you do double columns?

[inarbeth]

Here's a charting question.
I want to create a stacked column chart with two parallel data series. On the X-axis I will have the dates: 2002, 2002, 2007, 2007, 2012, 2012, 2017, 2017, 2022 and 2022. On the Y-axis rental figures in £.
The first stacked column for each of these years will show a base figure and a possible increase. The second stacked column for each year is to show the same base figure and a different possible increase. Has anyone done this or can anyone suggest a workaround?
The chart is to be used in a presentation to show the effects of index-linked increases on rents for buildings.

 

[Andrew Poulsom]

Rearrange your data so that you only have one set of dates - 2002, 2007, 2012, 2017 and 2022. Plot your first set of data as Series1 and your second set as Series2.

 

[inarbeth]

Andrew, that does not seem to work. I want two columns for each year. I am indifferent whether the year is repeated as an axis label. Column 1 for each year has Series 1 and Series 2 numbers. Column 2 for each year has Series 3 (identical to Series 1) and Series 4 numbers.

 

[Andrew Poulsom]

Plot Series1 and Series2 on the Primary y axis. Plot Series3 and Series4 on the Secondary y axis. Then adjust the Gap Width for one of the groups (Format Data Series, Options tab). The bars will overlap.

It will also work if you set out your data like this if you don't mind repeating the years:

<pre>
2002 2002 2005 2005 2012 2012
100 200 300
110 220 330
100 200 300
120 240 360
</pre>

 

[Mark W.]

See http://support.microsoft.com/default.aspx?scid=kb;en-us;Q77241

 

[inarbeth]

Thanks Andrew and mark. I'll look at this tonight when I get home.