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.
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.

Signature
Cheers
Andy
http://www.andypope.info
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.

Signature
Regards,
Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
> 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.