PC Review


Reply
Thread Tools Rate Thread

Chart size relative to contents

 
 
billinr
Guest
Posts: n/a
 
      3rd Feb 2010
2 questions:
1.) I have a chart which plots circles in an X Y scatter. Based on the size
of the circles within the chart, the circles appear as an ellipse.
I can resize the chart manually to bring the circles back to shape - I was
wondering if there was some quick VBA to make the chart area relative to the
X and Y axis length.
2.) I use these charts as a template, so the data changes. If I know the
extreme X and Y values, is there a method to control the axis length with
that information - while still taking advantage of the "automatic" scaling
feature? (this will be incorporated into the above question)

Thanks in advance for the consideration.
 
Reply With Quote
 
 
 
 
Herbert Seidenberg
Guest
Posts: n/a
 
      7th Feb 2010
Excel 2007 Chart
Scale X, Y axis to round circle.
With spinners, macro and cognitive feedback.
http://www.mediafire.com/file/dnyy2zitiii/02_06_10.xlsm
 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I change size of chart Legend without losing half of the contents? Chris Mitchell Microsoft Excel Discussion 1 2nd Feb 2010 05:39 PM
Re: How can I change size of chart Legend without losing half of the contents? Chris Mitchell Microsoft Access 0 2nd Feb 2010 05:33 PM
How can I change size of chart Legend without losing half of the contents? Chris Mitchell Microsoft Access 0 2nd Feb 2010 05:32 PM
Work sheet size relative to screen size =?Utf-8?B?RmxvcmlkYSBUb20=?= Microsoft Excel Misc 1 16th Apr 2007 02:22 AM
Size of superscript and subscript characters relative to Font size =?Utf-8?B?Qm9i?= Microsoft Word Document Management 1 25th Mar 2005 03:38 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:41 PM.