View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
A Pragmatic Cynic
 
Posts: n/a
Default XY Plot Size of Marker

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).