Grouping Data for a chart

Grouping Data for a chart

I have real estate data I'm working with and want to show how many agents sell 1 house a year, how many sell 2 homes per year, etc.
I'm trying to make a chart and not sure how to define the X and Y axis.  

Each row in my table is 1 real estate transaction with an associated agent ID.  

It will look something like this when complete

1     XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
2     XXXXXXXXXXXXXXXXXXXXXXXXX
3     XXXXXXXXXXXXXXXXXXX
4     XXXXXXXXXXXXXXX
5     XXXXXXXXXXX
6     XXXXXXXX
7     XXXXX





    Zoho Pagesense Resources

        Zoho SalesIQ Resources



              Zoho TeamInbox Resources

                Zoho DataPrep Resources


                    Zoho CRM Plus Resources

                      Zoho Books Resources


                        Zoho Subscriptions Resources

                          Zoho Desk Resources

                            Zoho Projects Resources


                              Zoho Sprints Resources


                                Qntrl Resources


                                  Zoho Creator Resources


                                    Zoho WorkDrive Resources




                                        Zoho Campaigns Resources

                                          Zoho CRM Resources

                                                      Design. Discuss. Deliver.

                                                      Create visually engaging stories with Zoho Show.

                                                      Get Started Now