Can i drop the year from dd/mm/yyyy for graph

  • Thread starter Thread starter Chris26
  • Start date Start date
C

Chris26

Hi
I am using Excel 2007

Column A Column B
1 Jan 2000 75.55
2 Jan 2000 75.37
to
31 Dec 2009 74.98

I have data spanning a number of years. I would like to plot that data on
same "line graph" to compare profiles of each year and values for any given
day/month. Can I get excel to "Ignore" the Year and just use the day/month
portion of the date. If not can anyone recommend a workaround.
Horizontal scale to be 1st Jan to 31st Dec. Then the vertical scale to be
based on Column B

Many Thanks
Chris
 
Insert a column between A & B. Formula is:
=DATE(2000,MONTH(A1),DAY(A1))
Copy downward.

Now use the new column B and C in an XY plot.
 
Back
Top