I have an Excel table which is simply one column of dates. Each date has a distinct value, and they are already sorted. Something like:
I would like to produce a chart from this where the X axis is time and the Y axis is the row count for that time, like this:
I can do this by introducing a new column with a value of
=Row() and charting both columns, but this seems silly and inelegant. Can Excel plot this chart without me going through this additional hoop?