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

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

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

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Chris26" wrote:

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

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

Answered when you asked earlier in another thread.
--
David Biddulph

"Chris26" wrote in message
...
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