Line chart question

[Steve]

I have a column of data that I want to display showing a
progression based on the number of rows per date.
See below. . . there are 6 rows on 3/29, 3 rows on 3/30,4
rows on 3/31, etc.

Any suggestions on how to do this and how best to display
it?

Thanx in advance!

3/29/2004
3/29/2004
3/29/2004
3/29/2004
3/29/2004
3/29/2004
3/30/2004
3/30/2004
3/30/2004
3/31/2004
3/31/2004
3/31/2004
3/31/2004

 

[Debra Dalgleish]

Assuming there is a column heading ("Date"), create a pivot table from
the data, with Date in the row area, and Date in the data area, as Count
of Date.

Create a pivot chart or a normal chart from the data.

There are instructions and links on Jon Peltier's site:

http://www.peltiertech.com/Excel/Pivots/pivotstart.htm