Plotting Step Graph with XY Scatter

[Ralph Heidecke]

I am trying to plot a graph that has a step graph representing theoretical
perfromance of a variable versus actual.

The steps are:

For X of 255 or less y = 148.5
for X 256 to 294 y = 158
for X 295 to 324 y = 162
and for X 325 and up y = 165

I want this to produce a graph line that literally looks like a stair case
where the line from 0 to 255 is horizontal along 148.5 and then rises
vertically to 158 then horizontal to 294 etc.

I then want to plot a second series as an XY scatter of more than one
hundred actual results.

Is there a way to do this either with the chart wizard or VBA?

 

[Andy Pope]

Hi,

Here are a couple of step chart examples.
http://tushar-mehta.com/excel/charts/step_chart/index.html
http://www.andypope.info/charts/stepchart.htm

Cheers
Andy

 

[Ralph Heidecke]

thanks these sites gave me what I needed to produce the graph.