I am graphing a two-column data set that looks like this:

1/1/1963    3,209,827,882
1/1/1964    3,281,201,306
1/1/1965    3,350,425,793

But when I try to set the Value Labels in either a Line Chart or a Scatter Plot to "Date & Time" or "Duration" I find that they are greyed out.

Why would this be? In what situations is it possible to use these two options?

enter image description here

enter image description here


Make sure the source columns are formatted as the proper date/time format.

| improve this answer | |

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .