I'm sure this question has been asked a thousand times...

How do I chart a time series (a series of dates with a value associated with
each date)? The dates are not evenly spaced, and I would like the axis to be
labeled with each actual date, rather than a series of evenly spaced dates
not associated with the data?

I've created a chart that does what I want, but the X axis shows a series of
evenly spaced dates, not the actual dates for each data point. Under Chart
Options / Axes / Value (X) Axis, I see Automatic/Category/Time Scale radio
buttons. I suspect Time Scale might be what I want, but the radio buttons
are grayed out.

Thanks for any help.