Arrange your data in two columns:

Month Value
Jan 1
Jan 2
Jan 5
Jan 10
Jan 7
Feb 3
Feb 5
Feb 9
Feb 3
Feb 1


Make a pivot table (Data menu). Drag the data field to the Rows area, drag it again to the Data area. Double click on the Value field button (labeled Sum of Value) and change the measure from Sum to Count. Drag the Month field to the Columns area. Here's the pivot table:

Count of Value Month
Value Jan Feb Grand Total
1 1 1 2
2 1 1
3 2 2
5 1 1 2
7 1 1
9 1 1
10 1 1
Grand Total 5 5 10



"john mcmichael" wrote in message ...
I am trying to create a chart from a data table in Excel that has months on
the left and numbers listed horizontally across a row.

Jan 1 2 5 10 7 etc
Feb 3 5 9 3 1 etc

I would like to create a chart that shows the data with months on the left
and the numbers across the bottom and then plots points that would show me
that in Feb, I have the number 3, 2 times.

Is something like this possible?

Thanks for any advice you can provide on this very unusuall chart.