Hi there!
I wanted to know if it was possible to easily create an interaction plot with two factors in Calc.
My spreadsheet basically has 3 columns: the Genotype (5 values), the Treatment (3 values) and the data collected. I want to compare the means of the data between Genotypes AND treatments.
So, this is what I get in Calc when I use one data range with the two factors in "categories":
And this is what I would like to get (obtained in R):
I guess I could add cells to have the means, then create a dataset for each treatment, and then add error bars, but there should be a cleaner and easier way to do this, shouldn't it?
Here is an example of dataset: http://dl.dropbox.com/u/1755762/Dataset%20example.ods
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-07-19 11:06:42 +0200
Seen: 132 times
Last updated: Jul 20 '12
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
Hmm - would it be possible to show an example of the data source? This would make it easier to find a solution how to create a chart based on that data.
tohuwawohu ( 2012-07-19 11:25:42 +0200 )editI added an example of dataset in the description. I couldn't upload directly in Ask Libreoffice: I always get an error ("data is null"), and it is the same with images.
UbuntuBrisbane ( 2012-07-20 04:37:24 +0200 )edit"...there should be a cleaner and easier way to do this, shouldn't it?" Not really. A spreadsheet is designed to hold the full dataset, which a chart then selectively makes use of. You are going to need to interpolate the data (means) in the sheet, rather than chart. That is how I would do it.
oweng ( 2012-07-20 08:39:46 +0200 )edit@UbuntuBrisbane: i'm sorry, i agree with @oweng, i fear this exceeds calc's capabilities without modifications of the datasource. Regarding upload problems: you're right, this is an annoying AskBot bug - AFAIK the admins already tried (unsuccessfully) to fix it by updating the software... :-(.
tohuwawohu ( 2012-07-20 14:55:00 +0200 )editHi @UbuntuBrisbane, Did you find an answer to your problem?
qubit ( 2013-01-29 09:32:48 +0200 )editNo, qubit, I have to use another software to produce this kind of graphs.
UbuntuBrisbane ( 2013-02-16 04:02:08 +0200 )edit@UbuntuBrisbane -- Ah, okay, sorry to hear that. I'll close out this question.
qubit ( 2013-02-16 04:13:21 +0200 )edit