Thread: Multi- charts
View Single Post
  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default

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