Re: How to force spreadsheet to create printable graph with same scale in X and Y?
Hi Steve: It's one of the reasons why I prefer to use gnuplot, rather than Excel, for some plotting tasks. Gnuplot is dead easy to use and comes in different flavours for different operating systems: http://www.gnuplot.info/ -- Richard On 21-Jun-11, at 8:29 PM, Steve Lelievre wrote: 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 - | Richard B. LangleyE-mail: l...@unb.ca | | Geodetic Research Laboratory Web: http://www.unb.ca/GGE/ | | Dept. of Geodesy and Geomatics EngineeringPhone:+1 506 453-5142 | | University of New Brunswick Fax: +1 506 453-4943 | | Fredericton, N.B., Canada E3B 5A3| |Fredericton? Where's that? See: http:// www.fredericton.ca/ | - --- https://lists.uni-koeln.de/mailman/listinfo/sundial
How to force spreadsheet to create printable graph with same scale in 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
Re: How to force spreadsheet to create printable graph with same scale in X and Y?
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 steve.lelievre.can...@gmail.com wrote: From: Steve Lelievre steve.lelievre.can...@gmail.com Subject: How to force spreadsheet to create printable graph with same scale in X and Y? To: Sundial List sund...@rrz.uni-koeln.de 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