Help required in Excel Charting

[raja_turbine]

Friends,

Please refer to the attached Sheet.

I have some data in " data available". Its something like, say from
this km to this km, the # of birds observed is this much.

And I need to generate a chart, that appears as in " Chart I need"

I have used a scatter plot here using the data I copy into " How I
arrange the data".

I have these questions.

1) I need a chart like what I have shown.
2) Is copying the data into the second sheet and charting based on the
data inthe second sheet the only option available?
3)If yes, what is the alternative?
4) If no, I want to automate this entire process using some formulas
and Excel functions.

This is very necessary considering the fact that, I have thousands of
rows of such data.

Thanks and regards
Raja

Attachment filename: test.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=409578

 

[Frank Kabel]

Hi Raja

have a look at this link for stepped charts. Maybe it will help
http://www.tushar-mehta.com/excel/charts/step_chart/index.html

Frank