Plotting duration of activity on a graph

[MJKelly]

Hi,

I need to add the following data to a graph.

Activity Time (secs)
pick 1
read 2
walk 9
pick 2


I need the chart to display the first instance of pick for 1 second,
along the time axis, then plot the next value (read) for two seconds,
and so on. However, I want either oe continuous bar or column, or a
three stage plot on the chart so I can see the different activities
over time. Sorry I've not explained myself very well. It would
basically look like a stacked chart, but without all the instances of
the same activity added together.

Hope you can help?

Matt

 

[Jeff]

Have a look here for some good charting tips

http://peltiertech.com/Excel/Charts/index.html