Hello,

This can be achieved quite easily. Kentico CMS features a built-in functionality to create reports and graphs from any database data. To make such a graph, you need to create an empty report in CMS Desk -> Tools -> Reporting -> [New category] -> New report first.

After that, navigate to the bottom of the new report view and select Graphs -> New. Enter a new graph name and an SQL query to fetch the data from the database, for example:

SELECT ItemText, ItemValue FROM Form_MySite_MyBizForm

Afterwards save the graph and the report. To display the graph on the site, place Report chart web part in the template and select your report and graph to be shown.

Best regards,
Filip Ligac