How to overlay graphs with different years in x axis

I have production data for dates for different years (daily data).

I would like to overlay the graphs with in x the data per day for each year (from January 1st till december 31st) and in y the production data. With this I am hoping to have curves for each year on the same graph.

I don't want the curves of each year to follow each other!!

I also made a filter because I don't want to use zeros on my graphs (already done). So the data on x aren't always the same (since I have dates without anything a year but the next year I do...)

Is there a way to plot these curves in excel without using VBA?

I was thinking doing a column with dates without the year but that doesn't work (since leap year exists :p )

Hope this is clear enough as question...

Hi noboffinme,

I was more thinking of putting on my x-axis Jan 1st, Jan 2nd, Jan 3rd, etc. but everytime excel adds the year.

Is it not possible to just have to month and date, regardless of the year?

I think this will be easier to overlay my different graphs, don't you think?

Andy Pope,

Looks pretty awesome what you did.

I have one question still remaining about your file : How can I do to not show the zeros and the #N/A on the graph?

Exemple.JPG

This a example of some of my data with one cell with the formula I used

Exemple 2.JPG

This is the graph

I found a solution :

You add a column with v and the data that had zero you creat a cell with =IF(cell="v",IFERROR(cell,0),0). You just have to change whenever a data needs a v or not manually.
I then created a new column to change the 0 of my calculation to #N/A using : =IF(SUM(cell)=0,NA(),SUM(cell)).

Then I created a new sheet where I put in a column the data for every year separetly. And I created a column with every date on a year (I created a counter) without the year.

Then you can plot a scatter for each year and it works perfectly :D

Thank you all for your help