OpenOffice.org Calc - Switching Axes in XY graph?
I've spent the last hour trying to fix one graph. I have two columns of data points, but Calc insists on graphing x vs. y, where I want y vs. x. I do not want to switch the columns physically in the table, but rather, I want to switch the association of the data sets with the axes. How do I switch this?
(So I have one column of absorbances and another of times. Right now, it has time as the y-axis, where it clearly should be the x-axis. How do I change that?)
Of course, I can physically arrange the data table so that the x-axis would be to the left of the y-axis, but that would be ridiculous as the only option. Can someone show me a way around that?
Last edited by apachedude; 12-05-2004 at 03:09 AM.