# Stacked columns in charts - can you do double columns?

#### inarbeth

##### Well-known Member
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.

### Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
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.

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.

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>

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

Replies
0
Views
972
Replies
1
Views
491
Replies
2
Views
679
Replies
0
Views
191
Replies
2
Views
2K

1,221,127
Messages
6,158,101
Members
451,464
Latest member
Holden3

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back