If you can write the SQL to extract the data you want to plot, Plotalot will use the Google Visualization API to dynamically draw various different charts or tables, with numerous formatting options. The paid version includes the Plotalot Plugin, which allows you to place charts anywhere in any article. The plugin also provides additional advanced features.

Line graphs, scatter graphs, and area graphs with multiple plots
Horizontal or vertical stacked or grouped bar charts
2D or 3D pie charts and donut charts
Gauges, timelines, bubble charts
Combo charts, Candlestick charts
Org charts, tree map charts, geo charts
Legend at top, bottom, left, right, or none
Optional grid
Titles and axis labels can be simple text or SQL queries
Axis limits can be automatic, fixed, or SQL generated
Charts can be responsive, and can refresh automatically without re-drawing the whole page
Three types of tables, including fully responsive CSS tables
Single items merge data from your database seamlessly into articles
Query the local site database or any other supported database
No libraries to install, just a component and an optional plugin
Charts can be cached on your web-server to reduce database load
Plotalot can be built in to your own code to add charting to your own extensions
Usage is fully documented in a free PDF user guide.