Plotalot

If you can write the SQL to extract the data you want to plot, Plotalot will use the Google Charts API to produce line graphs, scatter graphs, bar charts, or pie charts, with numerous formatting options. 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. * Line graphs with multiple plots * Scatter graphs with variable dot sizes * 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 * Chart size up to 300,000 pixels * Background colours, gradients, transparent, or semi-transparent * Data value markers, line fills, range markers * 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 save on database load * Charting class can easily be built in to your own code to add powerful charting to your own components