On Mon, 11 Jun 2007, in microsoft.public.excel.charting,
PierreL said:

The graph in its simplest form should look like a series of horizontal
bars showing the average, the length of the bar being duration or
distance covered. Stock charts show the min,avge,max value but the
width of the vertical bar is constant and does not vary with the
duration or distance.

It sounds as though you want a stepped Line chart, or a stepped stacked
Area chart. You can build this using the "Time-scale" X-axis type,
making sure that time T, the time of switch-over from one average to the
next, is represented *twice* in the data; once for the previous average
and once for the new average. This turns the sloping lines of a line
chart into a stepped pattern of horizontal and vertical lines.

You can choose the time-scale X-axis by selecting "Chart Options" in the
chart menu, and clicking the radio button marked "Category (X)
axis/Time-scale". Make sure that your times are in a numerical format,
and are positive numbers between 0 and about 2.9 million, like allowed
Excel dates. (actual date and time format should be fine)

Blank rows in the data table will eliminate the vertical lines if you
don't want them, leaving only the horizontals.

An alternative method would be to use X-error bars, of width set to
match the times. Each switch-over time is then represented only once in
the data table, and you will have a second column for duration,
calculated from the differences in times, from which the X-error bar
widths are taken.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.