Charting Sunrise / Sunset
 

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

Charting Sunrise / Sunset
 

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

Charting Sunrise / Sunset
 

Hi,

Just a simple x-y plot might suffice,with date along the x axis, and the
sunrise and sunset times plotted as separate series on the y axis.
You may wish to change the layout of the data so it's all in three columns,
ie February continues under January, etc.

Dave

url:http://www.ureader.com/msg/10296509.aspx

Charting Sunrise / Sunset
 

[The advice is generally to do the data manipulation in your worksheet, and
hence make the charting a simple process.]

I always tell people to spend five minutes with their data, it will save
five hours of frustration.

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


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
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

Charting Sunrise / Sunset
 

"DavidJ726" ha scritto nel messaggio
...

[cut] http://aa.usno.navy.mil/data/docs/RS_OneYear.php
-----
(thank for the link.
http://www.prodomosua.eu/zips/nightandday.xls
[excel2003, italian])
.f