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
Many of the charting tools available for Joomla (that I have tested) can do a good job of charting simple tables of numbers and Plotalot is no exception. So, even if your requirements are simple, Plotalot's easy to understand interface will allow you to get started quickly.
However, if you have more sophisticated requirements Plotalot is really the only option there is for Joomla. My charts are all based on MySQL tables. If you can write SQL queries you can access your data and create charts with Plotalot.
Finally, their support is great although I have rarely needed it. I had a simple technical question and received a quick response from the Plotalot team. They pointed me in the right direction and I was able to solve the problem quickly.
I strongly recommend Plotalot for your charting needs. (And the price is right too!)
It is said that you need some SQL knowledge before using the component - but in lack of other alternatives - and because the component was free, I gave it a chance anyway. I had practically never heard of SQL and mySQL before using this component.
I found that it is perfectly possible to insert data manually in this component. Just look at the examples. With a nice little excel document, I insert my sales data report in sheet 1 and the following sheets "spit out" the proper SQL terms for me to copy and paste into joomla.
Thanks for a great tool!
I have stumped up the small fee for the commercial verion so that I can embed charts directly in my articles. The results look magic!
for my needs, the simplicity of working with tools i know (mysql queries and joomla and php) far outweighed all of the features i found cumbersome in the commercial products. plotalot is 128K download and the others are bloatware over 500M (3000x bigger) requiring servers and workstation code and jvm's and .net and odbc drivers that were fragile. crystal dashboards even requires microsoft excel. who do they sell that stuff too?
plotalot just works, fits like a glove into a joomla app and is totally customizable with php and SQL. THANKS for offering it at this price (and thanks to google for the free charting apis that make it possible).
Providing the component for free is excellent as you can try out all the features and check it does what you need before spending any money which I am about to do as I need the plug-in and the price is excellent value for money!
The documentation and support are also first rate.
I contacted Chris with a question regarding plots with no data. Within 12 hours I had a reply and an updated component that totally solved the problem. You don't get that level of response from many of the "big players"!
Keep up the good work Chris, and, for anybody who requires charts / graphs on their site - look no further!
There are plenty of functional attributes could bring more value to this component.
Unlike other component they deliver flash based charts which wouldn't function in iOS based gadgets. This components deliver charts that would across the platform which is a plus.
In addition to the great functionalities inbuilt,if they could render the charts with little animation would bring more value to this component.
As the author an others have mentioned, you do need to know how to write SQL queries. However if know how to do it or you are willing to learn the results are easy. Simply create your query in your favorite SQL query tool, copy and paste the query into a new chart or graph, select the type of graph you want to use and save. You can instantly see the results in the component. When you are done it is super easy to insert the chart / graph into an article or HTML module.
I love the fact that this is a component. Other options I looked at were plugins. To me, I would much rather have a component to create and organize with.
Did I mention that it is really a great value for the price?
If you know how to do SQL, then you won't do much better creating charts and graphs than using Plotalot. Highly recommended!
Plotalot was recommended to me as the ideal companion for Fabrik and I have to say I have not been disappointed at all.
Plotalot is easy to use and the results are just plain "beautiful" to look at. Plotalot 3 uses Google's visualisation API.
I would say that you need to be able to write mysql queries, and to be fair the author points that out clearly and gives good advice in the excellent documentation.
Overall I would thoroughly recommend this product to anyone looking for an easy to use and robust graphing extension.
The extension works great from minute one, and a little problem I had, due to not reading slowly the usesrs manual, was solved within hours by support. Really excellent extension.
Off course did'nt read the manual first and started trying just like that. Thought that I had a good suggestion, quick reply that it was already possible. Fast and good support, even for a free product.
Very good backend to develop what you want !
I wish I could have hyperlink in the tables so It could fire another link to another report, drill down basically. I looked at Google APi and couldn'T find it how to make this happen. It would then be erfect for me but it is still a good application worth the price for sure.
Thanks for that. Other users have made hyperlinks in tables, and we'll be adding some examples to the user guide soon, so keep an eye out for a new version.
The only minor issue, is that the graphs miss the mark a bit.
Eg. if I have a value of 3, the the barchart is going to show below the line 3, and not right up to the line.
This problem certainly isn't normal. Please contact me so that I can investigate further.