how to plot time series data in excel? i have some data set like this : day between two dates are not fixed, sometimes 2 days, sometimes 3 days, .. 5 data are collected on certain day: 29/03/2013...26/03/2013 ...and so on.. thanks in advance for any help!!
....and more
Code:
[TABLE="width: 128"]
<tbody>[TR]
[TD="class: xl65, width: 64"]29/03/2013[/TD]
[TD="width: 64, align: right"]9[/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="align: right"]12[/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="align: right"]13[/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="align: right"]22[/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD="class: xl65"]26/03/2013[/TD]
[TD="align: right"]17[/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="align: right"]24[/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="align: right"]38[/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="align: right"]44[/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="align: right"]46[/TD]
[/TR]
[TR]
[TD="class: xl65"]24/03/2013[/TD]
[TD="align: right"]16[/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="align: right"]18[/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="align: right"]21[/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="align: right"]25[/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="align: right"]35[/TD]
[/TR]
[TR]
[TD="class: xl65"]22/03/2013[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="align: right"]18[/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="align: right"]24[/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="align: right"]27[/TD]
[/TR]
</tbody>[/TABLE]
