I wish to make an XY plot in Calc that has X-Y data from two different tabs in the same spreadsheet. A sample spreadsheet is attached to this message. I wish to plot time data in column A of Sheet1 on the X axis vs. the data in column B on sheet1 on the Y axis. To this I wish to add time data in column A of Sheet2 on the same X axis vs. the data in column B of sheet 2 on the same Y axis as a separate series. Note that the time data in Sheet 2 column A is has different values from that in Sheet1, but is in the same general time range. How can I do this?
Thank you for the help.
TestXYplot.ods (31.7 KB)
