Half Bar Graph / Half Stack Graph ??

L

LLC

I want to graph some data in a chart: I'd like the "Series
1" data source to show as a simple bar graph, but
the "Series 2" and "Series 3" data to show as a stacked
bar graph.

Here's the data:

---------------------
2005 2006 2007 2008
Series 1 7.0% 7.2% 7.4% 7.6%
Series 2 5.0% 5.2% 5.4% 5.6%
Series 3 2.0% 2.2%
---------------------

Meaning I want the graph to look like this:

---------------------

| |
| | | | | | |_| |_|
| | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | |

---------------------

The |_| stuff being the "Series 3" data on top of
the "Series 2" data.

Can this even be accomplished?
 
J

Jon Peltier

Through careful arrangement of the data in your worksheet, you can make
a stacked column chart that looks like a clustered-stacked column chart.

There is a tutorial showing this technique on Bernard Liengme's site:
http://www.stfx.ca/people/bliengme/ExcelTips/Columns.htm

which is based on the example on Stephen Bullen's web site:
http://www.bmsltd.ie/Excel/Default.htm
Go to Charting Examples, and download FunChart4.xls

The following MSKB article has an example:
XL2000: Creating Charts with Multiple Groups of Stacked Bars
http://support.microsoft.com/default.aspx?scid=kb;en-ca;214119


- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
L

LLC

"Careful arrangement" in NOT an understatemet! ;-)

I got it to work by using Bernard Liengme's example.

Thanks for your help.

LLC
 

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

Top