How do I create two stacked column graphs together?

[Guest]

I would like to create two separate stacked column graphs together (but not
one on top) in one chart, example : the severity (critical, major, minor) of
Calls and severity of defects should be shown two separate stacked columns as
month wise (time line as X-axis) in a single chart.
The data is like this:

 

[Guest]

make your stacked chart with three spaces per month
One for calls, one for defects and one blank. Put the month lable just in
the defect section.

 

[Guest]

This should solver your problem:
http://www.andypope.info/charts/stackside.htm

HTH
Ola Sandström


Closed 5 4
Open 3 5
Ca. Def. Ca. Def. Ca. Def.
Critical Major Minor

 

[Jon Peltier]

More examples:

http://peltiertech.com/Excel/ChartsHowTo/ClusterStack.html

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

 

[Guest]

Hi Ola,

Thank you very much, it is really helpful. The enclosed link answered most
of my questions.

Thank you once again.
Sarath GS.

 

[Guest]

Hi Jon,

Thank you very much, it is really helpful. The enclosed link answered most
of my questions.

Thank you once again.
Sarath GS.