[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/
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
