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

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
 
L

Luke M

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Format + Graph 2
Help with date format mm/dd/yyyy vs. dd/mm/yyyy 3
Combo Bar-Line Graph with single list of data 1
How do I eliminate the year in mm/dd/yyyy? 4
Macros to convert Data into date format and then plot in graph 7
Current year and current week number 11
Assign each week number to corresponding month of the year 5
How can I drop the year from mm/dd/yyyy data? 10

Top