Firstly, you'll want to convert the times in the format 1712 to Excel times in 17:12 format. One option is that when you transfer the text from the web page you could use Data/ Text to Columns in fixed width mode to split the hours and minutes to help you do that.
Secondly, if you want to produce a graph for the whole year your best bet is to include a column of dates through the year and list your sunrise and sunset times against each date. You can either copy and paste your monthly data into one series, or use formulae to extract the relevant data from your monthly columns.
The chart is then easy. [The advice is generally to do the data manipulation in your worksheet, and hence make the charting a simple process.]
--
David Biddulph
Rowing web pages at
http://www.biddulph.org.uk/
"DavidJ726" wrote in message ...
I can do simple charts & graphs, but this is a little more complex than what I'm used to. Can someone give me some pointers on how to create a graph / chart that shows the yearly sunrise & sunset? Here's a snippet of the data I'm working with and I think I got it from; http://aa.usno.navy.mil/data/docs/RS_OneYear.php

2 colums per month, 1 for the sunrise & 1 for the sunset, and the time for each day is in the rows.

Jan. Feb.
Day Rise Set Rise Set
h m h m h m h m
1 7:36 1712 725 1744
2 7:36 1713 724 1745
3 7:36 1714 723 1746
4 7:36 1715 722 1747



Thanks,
David