Charting like a staircase

[Daniel]

Good morning, Is there a way to chart a graph that looks like a staircase
where the X axis is form 0 to 12 and the Y axilx would be dollars. Say that
0 to 3 is one step the goes up (straight) one step that span form 3 to 6
etc.?

I have Office 2000.

Thank you for your suggestions

 

[Jon Peltier]

Daniel -

Go to Tushar Mehta's web site and look for the Step Chart page:

http://tushar-mehta.com

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Daniel]

Than you for the suggestion, I tried it and I can not succeed in getting the
steps to represent the same amount of period. I have 13 points (0 to 12)
and I have to split them equally. Also, I can not add that line in the
legend.

 

[Jon Peltier]

Daniel -

Tushar's example works for equal and unequal spacing between points. It
requires that you use an XY Scatter chart, because no other chart
provides horizontal error bars.

You could also make the chart by plotting each of the points. This
requires each X and Y value to be repeated in the data. It also requires
a Scatter chart. The data to process your original request would look
like this:

0 1
3 1
3 2
6 2
6 3

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______