How do I create two stacked column graphs together?
 

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:
-------------------------------------------
Critical Major Minor
Open calls 5 6 7
Closed calls 3 5 6
-------
Open Defects 4 3 4
Closed Defects 5 4 8
----------------------------------------------
Help me out this, this solution will really reduce my report size.

Regards,
Sarath.

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.

"Sarath GS" wrote:

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:
-------------------------------------------
Critical Major Minor
Open calls 5 6 7
Closed calls 3 5 6
-------
Open Defects 4 3 4
Closed Defects 5 4 8
----------------------------------------------
Help me out this, this solution will really reduce my report size.

Regards,
Sarath.

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


Critical Major Minor
Open calls 5 6 7
Closed calls 3 5 6
-------
Open Defects 4 3 4
Closed Defects 5 4 8
----------------------------------------------
Help me out this, this solution will really reduce my report size.

Regards,
Sarath.

More examples:

http://peltiertech.com/Excel/ChartsH...sterStack.html

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


Ola wrote:

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



Critical Major Minor
Open calls 5 6 7
Closed calls 3 5 6
-------
Open Defects 4 3 4
Closed Defects 5 4 8
----------------------------------------------
Help me out this, this solution will really reduce my report size.

Regards,
Sarath.

Hi Ola,

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

Thank you once again.
Sarath GS.

"Ola" wrote:

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


Critical Major Minor
Open calls 5 6 7
Closed calls 3 5 6
-------
Open Defects 4 3 4
Closed Defects 5 4 8
----------------------------------------------
Help me out this, this solution will really reduce my report size.

Regards,
Sarath.

Hi Jon,

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

Thank you once again.
Sarath GS.

"Jon Peltier" wrote:

More examples:

http://peltiertech.com/Excel/ChartsH...sterStack.html

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


Ola wrote:

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



Critical Major Minor
Open calls 5 6 7
Closed calls 3 5 6
-------
Open Defects 4 3 4
Closed Defects 5 4 8
----------------------------------------------
Help me out this, this solution will really reduce my report size.

Regards,
Sarath.