I think Tableau would be a great tool for your analysis. I took a look at your data, but I didn't really understand what I was looking at (for example, why are there 4 columns for each date?)
I think you would find Tableau very easy if the data was structured just a little differently. I re-shaped your data using the Tableau Data Reshaping Tool (you can read about it and download it here: http://kb.tableausoftware.com/articles/knowledgebase/addin-reshaping-data-excel). And I took some liberties with it to demonstrate an example of what could be done (for example, I just made up some dates since I didn't understand why there were multiple columns per date in your data).
I've attached the Excel file so you can see what it looks like now. Basically, data will be much easier if you can get a single record for each value of a measure and then provide some description of that measure (e.g. date, type, experiment group / control group, etc...). The more description you can provide the more interesting your analysis might be.
Feel free to ask additional questions! I or others here would love to help!
Thanks for providing me me an answer and further information. Now I understand it better. I've tried it on my own. there is just one tiny problem and that would be that me Time is as text. Something like this:
first week of July 2002, Second week of July 2002, ....., First week of July 2010 and so on.
When I try to plot it, all the First ones come together and second ones together and so on. So the timing on the X-axes is ruined. Is there anyway I can sort my data as it is in the excel sheet? Becasue in the excel sheet the order is correct.
Tanx in advance,
Would you mind saving the workbook and attaching it to a post. I think what you're asking is possible, but I'm not sure of how you have things setup at this point. Thanks!