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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 09:13 AM |
Report with Multiple Scatter Charts | Debbie | Setting Up & Running Reports | 1 | December 9th, 2004 04: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 04:54 PM |