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. Langley E-mail: l...@unb.ca | | Geodetic Research Laboratory Web: http://www.unb.ca/GGE/ | | Dept. of Geodesy and Geomatics Engineering Phone: +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

Reply via email to