Even if you could get equalspacing, aspect ratios would still be a problem.
My solution was in both my Excel and Open Office spreadsheets (see my website) to also print a square box with diagnols to show a V or an A. Then changing manually the X span of the chart until the V or A apex measured 90 degrees. It may be a macro can add some bells and whistles, however, I avoid macros like the plague, for many reasons. I too, would like to see an elegant answer. Simon Simon Wheaton-Smith www.illustratingshadows.com Silver City, New Mexico W108.2 N32.75 and Phoenix, Arizona, W112.1 N33.5 --- On Tue, 6/21/11, Steve Lelievre <[email protected]> wrote: > From: Steve Lelievre <[email protected]> > Subject: How to force spreadsheet to create printable graph with same scale > in X and Y? > To: "Sundial List" <[email protected]> > Date: Tuesday, June 21, 2011, 5:29 PM > 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
