View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
James Silverton
 
Posts: n/a
Default xy scatter chart-How can you make the axis equal for a 1H:1V plot

mark wrote on Fri, 19 May 2006 12:35:02 -0700:

m The xy scatter chart seem to allow you to change the scale
m on the x and y axis independently and then automatically
m stretches the axis (x and y) to fit the page. the result is
m that the graph is not true scale in both directions.

But you can make the units of x and y the same and make the
chart area square by clicking on it and moving the markers. I
don't know how to do this automatically but I can do it
satisfactorily, IMHO, by eye. I suppose I could hold a ruler to
the monitor to make it more exact.

James Silverton.