Making charts in OpenOffice Calc
This is a fairly particular question, and one that I think the answer to will be fairly obvious to a more experienced user than myself, so please excuse my ignorance.
I have been inputing a bunch of data into excel spreadsheets, but I generate that data with some script that runs under Linux. I decided it would be easier to use OpenOffice Calc, but have run into this problem.
How do I create charts of data that is not in columns that are right next to each other? Excel lets me pick series after starting the chart wizard, does Calc have a similar option? I want to be able to mess with the ranges of data plotted, and which columns make up the x and y axes values.
Any help will be greatly appreciated, as this is really the last step I have to take in escaping the clutches of Microsoft.