Help required in Excel Charting

  • Thread starter Thread starter raja_turbine
  • Start date Start date
R

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:confused:

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