PC Review


Reply
Thread Tools Rate Thread

Date Format + Graph

 
 
Chris26
Guest
Posts: n/a
 
      15th Jan 2010
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
 
Reply With Quote
 
 
 
 
David Biddulph
Guest
Posts: n/a
 
      15th Jan 2010
=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



 
Reply With Quote
 
Herbert Seidenberg
Guest
Posts: n/a
 
      16th Jan 2010
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
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't graph data with Date Format with hours BRB Microsoft Excel Misc 2 13th Aug 2008 10:13 AM
How do I graph data daily as a line graph across a calendar format =?Utf-8?B?R2xhbmk=?= Microsoft Excel Charting 3 23rd Nov 2007 09:05 AM
Break links automatically changes graph's date format WhytheQ Microsoft Excel Worksheet Functions 5 14th Jun 2006 12:27 PM
MS Graph - Date format on area chart Alan Z. Scharf Microsoft Access Reports 0 23rd Feb 2006 04:26 PM
code to convert date from TEXT format (03-02) to DATE format (200203) Gauthier Microsoft Excel Programming 0 22nd Sep 2004 03:26 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:15 PM.