Can I set up an area chart in Excel with stepped changes?

[simonjb]

I'm trying to plot the area of carrrigeways and footways from survey data.
Many of the examples are instances where the width/area changes at a
particular point rather than gradually. Excel area charts show the area
changing gradually - i.e. from trapeziodal rather than rectangluar
calculation.

 

[Andy Pope]

Hi,

If you use TimeSeries axis and provide the extra information then yes.
http://www.andypope.info/charts/stepchart.htm

Cheers
Andy

 

[Herbert Seidenberg]

Excel 2007
Put steps into your xy chart.
Macro converts trapezoidal data to rectangular data.
http://www.mediafire.com/file/2y5j3jj1j5z/start_stop.xlsm