Graphing Sunrise / Sunset times

[Chunky_22]

Hi All

I have a 3 column sheet. Column A is Date, Column B is Sunrise, Column C is Sunset. I have sunrise and sunset times for my location for the whole of 2008, and I want to show them as 2 lines on a line or XY graph.

My time format is 1:30:55 PM
My Date format is DD/MM/YYYY

My knowledge of graphing is very limited. Can anyone help?

Many thanks )

 

[iliace]

Insert a new chart. Your Category values will be in column A. Your Series1 will be called Sunrise, and the values for it will be in column B. Series2 will be called Sunset, and the values for it will be in column C.

Chart type for both series will be the xy plot that meets your requirements.

 

[Chunky_22]

Thanks - Your graph looks exactly what I need.

However, when I do this, I get a chart with weird dates on the Y axiz from 0/01/1900 to 15/03/2029, and numbers along the X axis from 0 to 400.

Totally not what my data in columns A,B and C looks like.

Can you tell me what I'm doing wrong here?

Many thanks

 

[iliace]

You have to select a categories list, for the X-Axis. I have circled in red the two series I have - Rise and Set. Date is not a series.

In light green I have circled the Rise series formula. You can see a sample of the data I'm using (data from US Naval Observatory) - the Rise is in column B.

Finally in blue I circled the Category axis data. This is column A, which in my data contains the dates.

When I first started the Wizard, Excel assumed that the date is also going to be a series. I had to copy the formula, paste it under Category axis labels textbox, and delete the unwanted Date series.

 

[Chunky_22]

Many thanks iliace, that's great. I've got it working now, thanks to your help.

Cheers