I am graphing a lot of data that depends on various parameters I am modifying. Some of these parameters change the amount of data that has to be displayed in the chart. So the range of the X axis needs to change with the data. I can't find a way to do this. The dialog settings for the X axis range don't allow spread sheet references or any other calculations I can see.
Any suggestions? Is this just not possible in OpenOffice Calc?
I have E-mailed you an E-book covering similar issues in Excel.
I suspect the tips will work in Open Office as well. ...Jim Thompson
I'd move to another app. Gnuplot if you're mostly graphing, Scilab if you need to incorporate significant number crunching, or R if you need heavy duty statistical analysis. All are free, with varying licenses.
In gnuplot, you would do something like: > set datafile separator "," > plot [3600:86400] "your_file.csv" using 1:2 with lines
will print the file's column 1 as x versus column 2 as y within the specified range of x. The range can be assigned to a variable as in > PMIN = 3600 > PMAX = 86400 > plot [PMIN : PMAX] "your_file.csv" using 1:2 with lines or > plot [PMIN * 2 : PMAX / 2] "your_file.csv" using 1:2 with lines etc.
Lots of flexibility & other options. Can print PDF files directly.
Have something to add? Share your thoughts — no account required.
Ask the community — no account required