creating a chart/graph

Good evening,

I was looking at creating a dynamic charts and graph and wanted to know if something like that would work for data being pulled from an SQL query?

SELECT category, COUNT(category) AS issue_count FROM ticket_view v GROUP BY category ORDER BY category

where i am just counting the records on the page and wanting to display them in a graph like below?

Graph Example:

Category:IS Security
Issues:2

Category:Maintenance
Issues:2

Category:Personnel
Issues:2

Category:Project
Issues:9

Category:Uptime
Issues:55

Hello,

Visit the following free chart controls

http://zedgraph.org/wiki/index.php?title=Main_Page

http://www.carlosag.net/Tools/WebChart/Default.aspx