Hi Steve,
I have fought with this ridiculous feature in Excel setting the scales so x
does not equal y. Looking good is all that counts in today's world! Fashion
leads function again. You can manually set the scale parameters for the
chart and make x about the same as y but this was not exact. As you found,
this is only as good as your eyes. Right click on the axis of the chart and
select the scale tab to manually change the scale to something that works
for you.
For a true chart, draw it in DeltaCAD.
Regards, Roger Bailey
--------------------------------------------------
From: "Steve Lelievre" <[email protected]>
Sent: Tuesday, June 21, 2011 4:29 PM
To: "Sundial List" <[email protected]>
Subject: How to force spreadsheet to create printable graph with same
scalein X and Y?
Hi,
I sometimes use a spreadsheet to calculate a series of X,Y points, and
then use these points to create a scattergram chart. My problem is that
whenever I do this, the chart appears on the screen as a rectangle. The X
and Y dimensions aren't to the same scale. I have to set the gridline
intervals to be the same for X and Y and then adjust the chart so that the
shape looks OK on screen.
My problem is that even if the chart grid appears to be in good proportion
on the screen, it's only as good as my eyes. What I really want is to
print an accurate diagram that I can use as an experimental dial. In
short, I want the printed chart to be on a square grid that is really
square.
Can anyone explain to me how to force the spreadsheet software to use
absolute distances for a printed chart's axes? Alternatively, a way to
force equal gridline spacing would be equally as helpful.
I use both OpenOffice and Excel - an answer for either one will be much
appreciated.
Cheers,
Steve
---------------------------------------------------
https://lists.uni-koeln.de/mailman/listinfo/sundial
---------------------------------------------------
https://lists.uni-koeln.de/mailman/listinfo/sundial
