Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
[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 |
#5
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
"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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Charting | Excel Worksheet Functions | |||
Charting help... | Charts and Charting in Excel | |||
Charting help! | Charts and Charting in Excel | |||
Sunrise / Sunset | Excel Worksheet Functions | |||
Custom charting - Stacked charting with a line | Charts and Charting in Excel |