[Gllug] Simple Openoffice spreadsheet question

[Russell Howe]

On Thu, Nov 03, 2005 at 05:26:52PM +0800, Richard Cohen wrote:
> All I want is a graph of balance against time

XY plot is what you're after, as others have said.

If you can't use 'date' as an axis, there should be a function called
DATEDIF which will return the difference between two dates as a
scalar number in the units you specify. Creating a column using this
function (e.g. =DATEDIF($A$2, <current cell reference>, "yd") ) and
plotting that against balance as an XY plot should work.

-- 
Russell Howe       | Why be just another cog in the machine,
rhowe at siksai.co.uk | when you can be the spanner in the works?
-- 
Gllug mailing list  -  Gllug at gllug.org.uk
http://lists.gllug.org.uk/mailman/listinfo/gllug