I looked at the Stepen's Funchart5 - the chart appears to be constructed by
Visual Basic or other programming language, how can I open the codes to put
in additional series?

From Stepen's example, if I have 3 cost of production (cost 1, cost 2, cost
3) and want them to be included in the stacked graphs, Is the following
amendment correct?

OFFSET WIDTH CHANGED TO 3:
rngVol=OFFSET(Sheet1!$B$5,0,0,COUNTA(Sheet1!$B:$B)-1,3)

NEW LINE: rngCost2=OFFSET(rngVol,0,3)

NEW LINE: rngCost3=OFFSET(rngVol,0,4)

AMENDMENT TO CREATE ADDITION BLOCKS FOR EARCH SERIES:
rngSer1=(IF(rngPlant=1,INDEX(rngCost1,1),0)),
(IF(rngPlant=1,INDEX(rngCost2,1),0)), (IF(rngPlant=1,INDEX(rngCost3,1),0)) -
repeat for each series




"Jon Peltier" wrote:

Oh, I understand. So many people say 'bar' when they mean 'column', that I
completely missed what you were saying.

The matrix bar chart requires a much more intricate process, because the
stacked area technique cannot be used. What you have to do is make a stacked
bar chart, with a couple hundred thin bars in each series. The bars have an
area fill but no border, and if you want borders, you need to construct XY
series (lines but no markers) to trace them. The basic technique is shown in
Stephen Bullen's variable width column chart example, but you use bars
instead of columns. His is the first link in this page:

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

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


"Sin" wrote in message
...
The article only give instruction on how to produce the Matrix Colum
chart,
how can I enhance it to produce the Matric Bar Chart?

"Jon Peltier" wrote:

The article's all about how to produce the chart. Any labels are placed
using dummy XY series to position points where desired, using no lines
and
no markers to format the dummy series, and applying data labels to these
points. You can use manual labeling via text boxes, if you don't mind
also
manually positioning the labels after any change to the data.

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


"Sin" wrote in message
...
Thx Jon.

Do you have any instruction on how to construct the Matrix Bar Chart?
In
addition, the article mentioned manual labeling method, does this mean
using
the Drawing tools or what is the method is it referring to? Does that
mean
we won't need to create scatter series if manual labeling was applied?

"Jon Peltier" wrote:

Perhaps this is what you want:

http://pubs.logicalexpressions.com/P...cle.asp?ID=508

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


"Sin" wrote in message
...
I have created a Stacked column graph showing 5 layers of amount,
within
each
layer, the amounts is shared between 3 parties in different
proportions, I
was the graph to show the different proportion between the parties
in
each
layer - i.e. like creating bar chart in each layer or a pie chart
effect
in
each layer ( or stacked column), is this possible to achieve?