A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Scatter charts -- can I lock in a 1:1 aspect ratio for axes?



 
 
Thread Tools Display Modes
  #1  
Old May 26th, 2005, 06:36 PM
external usenet poster
 
Posts: n/a
Default Scatter charts -- can I lock in a 1:1 aspect ratio for axes?

Hi all...

I most often create scatter charts, but really want to lock the aspect
ratio between the x and y axes. Haven't been able to find a setting for
this. I suppose I could write a VBA routine, but thought I should ask first.

Regards,
mvsmith




  #2  
Old May 27th, 2005, 03:47 AM
Jon Peltier
external usenet poster
 
Posts: n/a
Default

You might have some luck with this:

http://peltiertech.com/Excel/Charts/SquareGrid.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


MVSmith wrote:

Hi all...

I most often create scatter charts, but really want to lock the aspect
ratio between the x and y axes. Haven't been able to find a setting for
this. I suppose I could write a VBA routine, but thought I should ask first.

Regards,
mvsmith




  #3  
Old May 31st, 2005, 08:56 PM
external usenet poster
 
Posts: n/a
Default

Hi Jon,

Thanks! That works pretty well, and I can adapt your code
as needed. Most grateful...also some cool links at your website
on VBA.

Regards,
mvsmith


"Jon Peltier" wrote in message
...
You might have some luck with this:

http://peltiertech.com/Excel/Charts/SquareGrid.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


MVSmith wrote:

Hi all...

I most often create scatter charts, but really want to lock the aspect
ratio between the x and y axes. Haven't been able to find a setting for
this. I suppose I could write a VBA routine, but thought I should ask first.

Regards,
mvsmith




 




Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
a VBA question - capture scale of a graphic? Gregg Powerpoint 5 May 13th, 2005 09:52 PM
Locking the scale ratio of X-Y axis in XY scatter charts DK-Mech Charts and Charting 4 January 28th, 2005 10:13 AM
Report with Multiple Scatter Charts Debbie Setting Up & Running Reports 1 December 9th, 2004 05:36 AM
set width and height without lock aspect ratio murali Powerpoint 2 September 27th, 2004 02:47 PM
Chart aspect ratio streched when pasted into PP George wilson Charts and Charting 4 February 9th, 2004 05:54 PM


All times are GMT +1. The time now is 01:49 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.