I have several thousand cells of numbers, each representing a percentage of shellfish weight taken on a specific date. The data set spreads from 1999-2004.
I am plotting a time scale graph of these data points however when plotted, the graph is extremely wide - seeing the x-axis goes from Jan, 1999- through 2004 and I must go in 7 days increments.
I can set the x-axis to cover jan- Dec and have it YEAR neutral and plot all the data that way....the problem is that for the few thousand cells of data, I must change all the dates to a common one. My questions are:
How can I change the YEAR referenced in all these cells to a common one, in one or two steps, rather than having to change it manually one by one?
Is there a better way to plot this?
thanks so much.
I am plotting a time scale graph of these data points however when plotted, the graph is extremely wide - seeing the x-axis goes from Jan, 1999- through 2004 and I must go in 7 days increments.
I can set the x-axis to cover jan- Dec and have it YEAR neutral and plot all the data that way....the problem is that for the few thousand cells of data, I must change all the dates to a common one. My questions are:
How can I change the YEAR referenced in all these cells to a common one, in one or two steps, rather than having to change it manually one by one?
Is there a better way to plot this?
thanks so much.