Stacked columns in charts - can you do double columns?

inarbeth

Well-known Member
Joined
Apr 8, 2002
Messages
912
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

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
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

Well-known Member
Joined
Apr 8, 2002
Messages
912
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

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
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>
 

Forum statistics

Threads
1,144,438
Messages
5,724,361
Members
422,546
Latest member
KevinOnTheDaily

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top