SQL Charts is free WordPress plugin which can create beautiful Local and Google Charts based on your SQL queries, then you can use those charts in any part of your website. You can use both native wp and non-wp mysql tables in your queries.
Building dynamic charts with this plugin is very easy. Just follow these steps:
1. Give any name to your report.
2. Use our preinstalled chart or create new one yourself: choose desired chart type, type sql query,
enter field names, labels and then press to Publish/Update
3. After update/save you will see needed shortcode below there. Then you can use that shortcode anywhere in your website: in pages, posts, widgets etc.
That’s, a shortcode for plugin is ready and you can use it anywhere your want inside your website.
The plugin is secure: Although only administrators can create new reports, the plugin allows “SELECT” queries only.