Did you try a bubble chart?
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
"A Pragmatic Cynic" wrote in
message ...
Is there any way to very the size of the markers on an XY Plot? Here is
what
I am trying to do:
Assume the following Data Set
Group 1: A=5, B=10, C=30, D=40
Group 2: A=25, B=10, C=5, D=25
Group 3: A=10, B=5, C=10, D=10
I would like the X axis to be Group 1, Group 2, and Group 3 and the Y axis
to be A, B, C, and D.
For Group 1 as it goes up the Y Axis, the marker on A would be 1/2 the
size
of the marker for B, which is 1/3 the size of the marker for C, C being
3/4
the size of the Group 1(D) marker.
In group 2, the A and D markers are the same size, and 2.5 times the size
of
the marker for Group 1(B). Marker 2(C) is 1/5th the size of 2(A) and
2(D),
etc.
Is this possible? If not is there a better option (and not stacked
columns
which my users cannot adequately comprehend).