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

#1 05-26-2005, 06:15 PM

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 05-27-2005, 12:05 AM

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 05-31-2005, 05:05 PM

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" <jonREMOVExlmvp@peltierCAPStech.com> wrote in message
news:Oo84xZmYFHA.3364@TK2MSFTNGP12.phx.gbl...
> 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	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)