Hello,
I would like to make a chart based on my data which are represented in two columns: date and value.
e.g:
I want to have the date and time on the X axis but the problem is that Excel considers only the date of the column and ignores the time in a day. In other words, I have one X value on the 1/8 00:00 and three values on 1/9 00:00
How can I make excel to "see" also the time of the day ?
edit: it looks like I have to use "Scatter" chart instead of "Line" chart
cheers,
Tex
I would like to make a chart based on my data which are represented in two columns: date and value.
e.g:
Code:
1/8/11 21:15 | 129
1/9/11 9:02 | 130
1/9/11 9:10 | 100
1/9/11 9:50 | 80I want to have the date and time on the X axis but the problem is that Excel considers only the date of the column and ignores the time in a day. In other words, I have one X value on the 1/8 00:00 and three values on 1/9 00:00
How can I make excel to "see" also the time of the day ?
edit: it looks like I have to use "Scatter" chart instead of "Line" chart
cheers,
Tex
Last edited: