CAn you supply some opf the folloowing, so I can help further, your previous comment didn't really build on it.

Do you have access to the SQL serv Query?

What version of SQL Server are you running

A sample table create statement with some example data inserted.

Sample select statement from your sample table

Example of how you want your chart/table to look (this can be in Excel, Paint, just something visual).

Please remember to include the SQL in brackets. It makes everyone's life a lot easier.

Thanks.