Hi, I hope one of you can help me today.
I have a program which finds the last treatment time for each day.
I have been asked to graph it in Excel with the dates as an x axis, the time on the y axis and of course, the values at the intersection of the date and time.
I have been at it all afternoon and cannot seem to get close. Either the time displays on the y-axis and the date on the x-axis and I get no values, or the values display and I cannot get the time and date values to display as axis labels. When the values display they are a datetime field. When the time displays on the y-axis it is a 12 am - 12 pm (this is OK). However, the dates on the x-axis must be the dates in the dataset.
I am no longer thinking clearly. I'm not even sure anymore which chart type to use. Any assistance that you can offer will be gratefully received and faithfully played with.
Thank you in advance.
I have a program which finds the last treatment time for each day.
I have been asked to graph it in Excel with the dates as an x axis, the time on the y axis and of course, the values at the intersection of the date and time.
I have been at it all afternoon and cannot seem to get close. Either the time displays on the y-axis and the date on the x-axis and I get no values, or the values display and I cannot get the time and date values to display as axis labels. When the values display they are a datetime field. When the time displays on the y-axis it is a 12 am - 12 pm (this is OK). However, the dates on the x-axis must be the dates in the dataset.
I am no longer thinking clearly. I'm not even sure anymore which chart type to use. Any assistance that you can offer will be gratefully received and faithfully played with.
Thank you in advance.