Step Line Charts

[Carrie]

Does anyone know how I can create a step line chart without having to have 2 data points per x-axis point. What I want is a horizontal line until the next data point and then I want the line to go vertical.

 

[Andy Pope]

Hi Carrie,

You Will need some form of extra data to get excel to create a step
chart. Take a look at these methods.
(http://www.andypope.info/charts/stepchart.htm)

Does anyone know how I can create a step line chart without having to have 2 data points per x-axis point. What I want is a horizontal line until the next data point and then I want the line to go vertical.

--

Cheers
Andy

http://www.andypope.info

 

[Tushar Mehta]

If you decide to go with a XY Scatter chart with error bars, you can
find step-by-step instructions at the Excel | Charts | 'Step Charts'
page of my web site.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions