Hello!
I have 2 columns of data--column B contains data corresponding to a date and time recorded at 10-min intervals in column A. I am trying to create a simple line graph of the data in column B over a month's time period, thus plotting over 4000 points.
My problem is, if I graph the data without specifying x-axis labels, the line graphs correctly, however, the x-axis gives numbers from 1 to over 4000 corresponding to the number of data points. If I specify column A as the x-axis labels, the axis shows say 10/1/2004 0:00, 10/2/2004 0:00...
10/31/2004 0:00, which is fine, but the graph becomes vertical lines above each date value.
What I want is for the x-axis to display the date as just described--10/1, 10/2, 10/3...10/31--which I can do by changing type under format axis number, and I want the graph to plot each 10-min point in a smooth line as it did when I didn't specify the x-axis.
How can I make this happen? Thank you for your help!
I have 2 columns of data--column B contains data corresponding to a date and time recorded at 10-min intervals in column A. I am trying to create a simple line graph of the data in column B over a month's time period, thus plotting over 4000 points.
My problem is, if I graph the data without specifying x-axis labels, the line graphs correctly, however, the x-axis gives numbers from 1 to over 4000 corresponding to the number of data points. If I specify column A as the x-axis labels, the axis shows say 10/1/2004 0:00, 10/2/2004 0:00...
10/31/2004 0:00, which is fine, but the graph becomes vertical lines above each date value.
What I want is for the x-axis to display the date as just described--10/1, 10/2, 10/3...10/31--which I can do by changing type under format axis number, and I want the graph to plot each 10-min point in a smooth line as it did when I didn't specify the x-axis.
How can I make this happen? Thank you for your help!
