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.
- Line graphs, scatter graphs, and area graphs with multiple plots
- Horizontal or vertical stacked or grouped bar charts
- 2D or 3D pie charts
- Gauges, timelines, bubble charts
- Combo 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
- Unlimited chart size
- Charts can be responsive.
- SQL can include various types of variables
- Query the local site database or any other MySql database
- Can also produce tables or single items (the first column of the first row returned by your SQL)
- No libraries to install, just a component and a 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 components
You can include as many charts as you like, anywhere in any article, using the Plotalot plugin. Usage is fully documented in a rather large, but free, PDF user guide.