Multi Column Stacked Bar Chart

cnJosephyne

New Member
Joined
Dec 8, 2009
Messages
4
Our office recently was upgraded to MS Office 2007, and I am having a pickle of a time trying to create a multi columned stacked bar chart.... its been a while but i am pretty sure this was easily done in the last version.... with the chart wizard gone from this version.. i am lost.

Any help would be great... Thx!
 

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

nicolewh

Well-known Member
Joined
Aug 7, 2009
Messages
554
select data ->insert tab -> Charts -> Select a column chart.
For more specifics you can click on that small arrow to the lower right of the chart section and a form appears with many more selections.
Can you just not find it or is the result not what you want?

Nicole
 

cnJosephyne

New Member
Joined
Dec 8, 2009
Messages
4
The result is not what I am looking for:
I want two columns, stacked, side by side for comparison...

the highlighted in green as one stacked column and the highlighted in yellow as another stacked column...

I get one stacked column with all info stacked... how can i divide this?
The chart doesnt seem to give me the option, or is it the layout of my data?
excel120809.txt
 

nicolewh

Well-known Member
Joined
Aug 7, 2009
Messages
554
Do you want the green highlighted row and the light green highlighted stacked one on top of another? And also the same with yellow/light yellow?

If so I don't think there is a way to integrate both stacked and column comparison charts.

But why don't you use Clustered Column - the first one if you want to compare side by side?
 
Last edited:

cnJosephyne

New Member
Joined
Dec 8, 2009
Messages
4

ADVERTISEMENT

Do you want the green highlighted row and the light green highlighted stacked one on top of another? And also the same with yellow/light yellow?

yes side by side in one chart for comparison....

edit: I should add as well that I have tried using a secondary axis but it doesnt seem to give me the formatting options as the older version of excel (right or left plotting...)..

Am i missing something?
 
Last edited:

nicolewh

Well-known Member
Joined
Aug 7, 2009
Messages
554
Select the data and try using Clustered Column chart. This will will show a side by side comparison.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,971
Messages
5,599,109
Members
414,289
Latest member
sonintebil

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