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

The steps a

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?

Hi,

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

Cheers
Andy

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

The steps a

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, Microsoft MVP - Excel
http://www.andypope.info

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


"Andy Pope" wrote in message
...
Hi,

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

Cheers
Andy

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

The steps a

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, Microsoft MVP - Excel
http://www.andypope.info