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?

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?

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?

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?

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?

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?