Hi Steve: I don’t think there is a specific command to do that in Excel (don’t know about Open Office) but I understand you can do it in Excel by using VBA. Have a look at this page: http://peltiertech.com/Excel/Charts/SquareGrid.html
Incidentally this Jon Peltier site has a wealth of other tips and tricks... Regards Patrick From: Steve Lelievre Sent: Wednesday, June 22, 2011 12:29 AM To: Sundial List 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
