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?