View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Chris26 Chris26 is offline
external usenet poster
 
Posts: 17
Default 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