View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rafael Guerreiro Osorio Rafael Guerreiro Osorio is offline
external usenet poster
 
Posts: 27
Default Proportional Chart

You could write some code to compare the maximum value of X and Y, and then
scale both axis considering the highest value.

Best,

Rafael

"Cody" wrote:

I am using a chart to visibly create an object. I would like to force the
scaling of the chart (xy scatter) to always be equivalent units (of length in
my case) in both axis directions. I like the chart to auto-scale for size
but if the chart scales different for each direction then my objects are
skewed.

If anyone has code ideas or suggestions I would greatly appreciate any help
I can get.

Thanks,

Cody