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...