Multiple Data sets on same chart

  • Thread starter Thread starter gschimek
  • Start date Start date
G

gschimek

I am wondering if this is even possible. Here's what needs to be done:

Creating a chart to compare shipping costs for our various location
diferentiating Priority verses Standard shipping. I'd like the char
to show Locations on the Y axis, and Dollar amounts on the X axis, wit
the data being pulled from two categories, Priority and Standard, an
that data needs to be stacked on top of each other to show the tota
amount spent.

OK, That part is easy. I can do that using a standard Stacked Ba
Chart. Now, what I want to know is if there is a way to Add anothe
week's data in exactly the same way to the chart. For example, I woul
have two stacked columns of data right next to each other for ou
Corporate office, one for week 1, one for week 2.

I hope that makes sense. Basically I'm trying to combine the Stacke
Columns with the Clustered columns look to it.

Any help would be appreciated
 
Through careful arrangement of the data in your worksheet, you can make
a stacked bar chart that looks like a clustered-stacked bar chart.

There is a tutorial showing this technique with column charts 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/
_______
 
Back
Top