Multi- charts
 

I want to diplay 5 rows of data on one chart.

3 of the rows I want stacked on the same bar (3 different status of one
product-so want the total as combination)

2 other single bars.

Paul

Paul -

Arrange your data like this with more appropriate labels than I've used
(view in Courier):

Position 1 Position 2 Position 3
Series 1 [value]
Series 2 [value]
Series 3 [value]
Series 4 [value]
Series 5 [value]

Select the entire range (including "Position" row and "Series" column)
and create a stacked column chart with series in rows.

Series 1, 2, and 3 will be stacked in the first position along the
category axis, while series 4 and 5 will be unstacked in the next two
positions. Actually they all are stacked, but the zero values don't show up.

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

Paul wrote:

I want to diplay 5 rows of data on one chart.

3 of the rows I want stacked on the same bar (3 different status of one
product-so want the total as combination)

2 other single bars.

Paul

John,

Many thanks for the solution. All the data is imbedded in an existing table,
but I will be able to create a hidden table referencing as you sugested.

Many thanks for this help.

Regards,

Paul

"Jon Peltier" wrote:

Paul -

Arrange your data like this with more appropriate labels than I've used
(view in Courier):

Position 1 Position 2 Position 3
Series 1 [value]
Series 2 [value]
Series 3 [value]
Series 4 [value]
Series 5 [value]

Select the entire range (including "Position" row and "Series" column)
and create a stacked column chart with series in rows.

Series 1, 2, and 3 will be stacked in the first position along the
category axis, while series 4 and 5 will be unstacked in the next two
positions. Actually they all are stacked, but the zero values don't show up.

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

Paul wrote:

I want to diplay 5 rows of data on one chart.

3 of the rows I want stacked on the same bar (3 different status of one
product-so want the total as combination)

2 other single bars.

Paul

See Stephen Bullen's funchrt4.zip at
http://www.oaltd.co.uk/Excel/SBXLPage.asp#Charting

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005

In article ,
says...
I want to diplay 5 rows of data on one chart.

3 of the rows I want stacked on the same bar (3 different status of one
product-so want the total as combination)

2 other single bars.

Paul