Cluster and Stacking Bar Chart

E

Englert

I need to create a bar chart that will stack and cluster
the data. Doing each seperately is simple, does anyone
know how to do both simultaniously?

Any help would be appreciated.

Thanks,
Englert
 
A

Andy Pope

Hi Englert,

This is a response Jon Peltier gave to a similar question a few days ago.

Quote:
You can make a clustered stacked column chart through clever arrangement
of your data in the worksheet. See the details at Stephen Bullen's site:
http://www.bmsltd.co.uk/Excel/SBXLPage.asp#Charting
and look at the description for FunChart4

or at Bernard Liengme's site:
http://www.stfx.ca/people/bliengme/ExcelTips/Columns.htm

I need to create a bar chart that will stack and cluster
the data. Doing each seperately is simple, does anyone
know how to do both simultaniously?

Any help would be appreciated.

Thanks,
Englert
Click to expand...

--

Cheers
Andy

http://www.andypope.info
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple stacked clustered bars 1
Charting 4
Can Excel produce a clustered and stacked column chart? 2
How to create a Stacked-Clustered Chart 0
Clustered-Stacked-Column Combo Chart With Lines 2
How do I create a combined 'cluster' and 'stacked' column chart? 1
Cluster Stacked Chart with Difference Embedded 1
How do I combine stacked and clustered chart types? 2

Top