Stacked + Clustered

A

AB

Hello,

How could I create a graph (chart) with both stacked and
clustered data?

For example, I have sales data per zones (North, East,
West, South). The data is further split into time-
quarters (Q1, Q2, Q3, Q4). Within this, there is a
further split based on hardware type A and hardware type B.

I wanted to create a graph that has as "X" axis the
zones. For each zone, I want one stack per quarter. Thus
all quarters are clustered together and in each quarter
the sales per hardware type are stacked.

How could we do this?

Thanks a lot for your ideas.
 
A

ab

Yes, that worked just fine. Thanks for the help.

This solution is good for a one time usage; but for a
repeated usage, is there a means to save a generic
template?
 
J

Jon Peltier

Actually, Bernard, the page of mine that Andy cites is only a list of
links, and yours is the first link. I like your explanation best for the
poor user who is having difficulties.

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

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 chart types on same chart 1
Excel 2003 - Combination chart: Stacked Column + Stacked Column 3
Clustered and stacked columns at the same time 5
Charting 4
Combination Column and Stacked Column Chart in XL 2007 1
How do I combine stacked and clustered chart types? 2
Percentages AND Value lables on Stacked Columns 1
Stacked Column and Clustered Column 1

Top