Using Excel 2007, I've got a set of data below and am interested in a couple of things:
Clock <=== Duration =======>
Time (s) Task 1 Task 2 Task 3
1.1 .25 .75 .33
2.1 .2 .6 .4
3.9 .5 .8 .3
5.1 .6 .7 .45
7.2 .3 .65 .4
I'm interested in visually depicting where the missing data probably is (Clock time = 3.0 & 6.0) and what the total duration of the Task 1+Task 2 + Task 3 is at a particular time point.
I'd like to use a stacked column chart so that I can see the duration of each task at a particular time point. I'd like the x-axis to plot using the clock time, instead of the 'category' type x-axis.
I've looked around quite a bit on the web and haven't had any luck
Any suggestions?
Clock <=== Duration =======>
Time (s) Task 1 Task 2 Task 3
1.1 .25 .75 .33
2.1 .2 .6 .4
3.9 .5 .8 .3
5.1 .6 .7 .45
7.2 .3 .65 .4
I'm interested in visually depicting where the missing data probably is (Clock time = 3.0 & 6.0) and what the total duration of the Task 1+Task 2 + Task 3 is at a particular time point.
I'd like to use a stacked column chart so that I can see the duration of each task at a particular time point. I'd like the x-axis to plot using the clock time, instead of the 'category' type x-axis.
I've looked around quite a bit on the web and haven't had any luck
Any suggestions?
