LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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).




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change the size of a chart marker in the legend Thea Charts and Charting in Excel 0 February 13th 06 08:38 PM
chart size zdenek Charts and Charting in Excel 0 February 9th 06 09:58 AM
Print Excel charts in Word 2003 with fixed size Phil Charts and Charting in Excel 1 November 3rd 05 04:24 AM
Can I copy x-y scatter plot data direct from one plot to another? Chris Charts and Charting in Excel 2 June 3rd 05 01:20 PM
Plot Wizard -- "Not enough system resources to display completely. Andrew Charts and Charting in Excel 1 April 26th 05 12:27 AM


All times are GMT +1. The time now is 06:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"