On Mon, 04 Feb 2008 13:45:22 -0800 Lou Fridkis wrote: > I am using the open office spreadsheet - Calc - to chart memory > usage. I want to make the x axis indicate the time and the y axis > indicate the date. The date and time data is in two columns. When I > change the range for one, either the x or secondary x, axis, the > other changes also, so they end up both displaying the same data no > matter what I do. I can effect the formatting, e.g. I can cause the x > axis to rotate 45 degrees and the secondary x axis to not rotate. > So, the question is: how can I specify different data for the x and > secondary x axis (e.g. x = a1:a2; secondary x=b12:b4)? > Thanks, > Lou >
This is a 3D chart you are looking at. Think X Y Z as depth. Or to keep it 2D either: * Combine your date and time into a single column. * Have a seperate column for each day if you wish to compare days. -- Michael All shall be well, and all shall be well, and all manner of things shall be well - Julian of Norwich 1342 - 1416 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
