Hi

I have 40 Years of data (2 Columns) in the following format

Column A Column B
1/Jan/1970 75.65
2/Jan/1970 75.70
to
31/Dec/2009 80.15

etc
What i would like to create is a simple line graph, with the horizontal Axis
being 1st Jan to 31st Dec (No Year Data)
Then my vertical Axis would be based on the values in Column B

Basically what i am looking for is to be able to compare each years data on
the same graph.
How do I set up the graph to only look at the Day/Month of the Date and
ignore the year when setting up the graph. Sure I have done this before but
cant get my head round it today !!!

Many Thanks
Chris

=DATE(2000,MONTH(A1),DAY(A1)) will transfer all the data to an equivalent
date in an arbitrary year so that you can use that as the x axis data.

Then put each year's data in a separate series on the plot.
--
David Biddulph

"Chris26" <(E-Mail Removed)> wrote in message
news:60D6F9D8-3B91-466C-88C7-(E-Mail Removed)...
> Hi
>
> I have 40 Years of data (2 Columns) in the following format
>
> Column A Column B
> 1/Jan/1970 75.65
> 2/Jan/1970 75.70
> to
> 31/Dec/2009 80.15
>
> etc
> What i would like to create is a simple line graph, with the horizontal
> Axis
> being 1st Jan to 31st Dec (No Year Data)
> Then my vertical Axis would be based on the values in Column B
>
> Basically what i am looking for is to be able to compare each years data
> on
> the same graph.
> How do I set up the graph to only look at the Day/Month of the Date and
> ignore the year when setting up the graph. Sure I have done this before
> but
> cant get my head round it today !!!
>
> Many Thanks
> Chris

Excel 2007 PivotTable, PivotChart
Year to year comparison.
No formulas or extra columns needed.
Avoids disastrous leap year problems.
http://www.mediafire.com/file/mjymiwznmzm/01_15_10.xlsx