Menu

Plotalot

December 9th, 2013

PlotalotIf 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.

You can include as many charts as you like, anywhere in any article, using the Plotalot plugin.

From version 3.06, Plotalot charts can be configured to be responsive.

Usage is fully documented in a rather large, but free, PDF user guide.

* Line graphs, scatter graphs, and area graphs with multiple plots
* Horizontal or vertical stacked or grouped bar charts
* 2D or 3D pie charts with or without values
* 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
* 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
* Charting class can easily be built in to your own code to add powerful charting to your own components