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
