Well... I wouldn't start with the chart.
Start by just creating a recordset that returns the correct data. It will be a matter of writing the correct SQL statements to get the data that you want.
Unfortunately it will be difficult for anyone to help you without knowing exactly what your database structure is and what data you are trying to get precisely from what columns.
You will probably have to give it some sort of try first, then post the SQL statement you are using and what does and doesn't work with it and somebody can probably help from there. There really isn't enough specific information about your database to give you the specific information you are looking for about how to get the information out of your database.