how to create scatterplot using counts of rows and date ranges?

1 view (last 30 days)
I have data that look like this
"Site Date AUTO ID
GRP-5 01-May-15 ANPA
GRP-5 04-Jun-15 ANPA
GRP-5 11-Jun-15 ANPA
GRP-5 12-Jun-15 ANPA
GRP-5 18-Jun-15 ANPA
GRP-5 19-Jun-15 ANPA
GRP-5 19-Jun-15 ANPA
GRP-5 13-Sep-15 ANPA
GRP-5 22-Sep-15 ANPA
GRP-5 26-Sep-15 ANPA
GRP-5 10-Oct-15 ANPA
GRP-1 16-May-15 ANPA
GRP-1 29-May-15 ANPA
GRP-1 08-Sep-15 ANPA
BUL-4 13-Aug-15 ANPA
BUL-4 16-Aug-15 ANPA
BUC-3 09-May-15 ANPA
BUC-3 09-May-15 ANPA
BUC-3 10-May-15 ANPA
BUC-3 29-May-15 ANPA
BUC-3 08-Jun-15 ANPA
BUC-3 10-Jun-15 ANPA
BUC-3 11-Jun-15 ANPA
BUC-3 11-Jun-15 ANPA
BUC-3 27-Jun-15 ANPA
BUC-3 24-Sep-15 ANPA
BUL-11 30-Apr-15 ANPA
BUL-11 08-May-15 ANPA
BUL-11 20-May-15 ANPA
BUL-11 26-May-15 ANPA
LBL-5 29-Apr-15 ANPA
LBL-5 03-May-15 ANPA
LBL-5 09-May-15 ANPA
"
How would the syntax be for a scatter plot by "Site" and a count of "AUTO ID" by month. Month would be on the x-axis and count would be on the y-axis. I would also like to have separate scatter plots for each site.
Thanks ahead of time for the help!
Alan

Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!