So far, I have shown you how to make Highcharts to use dynamic data using straight PHP. For most of our projects, we use CodeIgniter framework as it's convenient and forces all developers to stick to a structure. I assume that you are familiar with CodeIgniter so I will go straight into showing you how to [...]
Some of you were asking me to provide an example of Highstack using some dynamic data. Highsoft website only provides example using static file - http://www.highcharts.com/stock/demo. This is great but I needed to figure how to connect to a live ticker feed. Google and Yahoo used to provide finance API but they don't provide them anymore. [...]
In this tutorial, I will cover how to connect a Highcharts Stacked Area Chart to data from MySQL table. This chart type should be the last of the "standard" report types. If you want me to demonstrate other chart types, let me know in the comment section Step 1 - MySQL Step 2 - JSON Data [...]
In this tutorial, I will cover how to connect a Highcharts Bar Chart to data from MySQL table. It's almost identical to column chart in the previous post but the chart type is "bar". The nice thing about the bar chart is you can stretch out vertically if your categories don't fit horizontally. Step 1 - [...]
In this tutorial, I will cover how to connect a Highcharts Column Chart to data from MySQL table. Step 1 - MySQLI will re-use the same table structure and data from the last tutorial Stacked column chart with data from MySQL using Highcharts. Run the project_requests.sql in your MySQL database that I included in the download [...]
In the next batch of posts, I will try to provide dynamic examples of other chart types. I have covered the line and pie chart types so I will start providing other chart types. In this tutorial, I will show how to dynamically connect a stacked column chart to a MySQL table. Once you know how [...]
Last time, I showed you how you can get DHTMLX Grid to show your data. This time, I want to show you how to use the same JSON data to be used for Highcharts. Additionally, I will show a nice toggle effect that can be used to flip between a data grid and a chart. Credits:DHTMLX [...]
When you have charts and graphs in your system, inevitably there will be a requirement to include some sort of data table or data grid. If charts can provide overall visualization, data grids can provide exact numbers to be closely inspected. Many projects that I worked on usually required both charts and data grids. There are [...]
Having difficulty choosing the right chart type for your data? This is a great starting point. Choosing a Good Chart Type
When I first tried to use drill down example on Highcharts site, I noticed that the data is all static. I suppose you can load all the data at once but that might a lot of data depending on number of series items. Before looking at this dynamic example, you should familiarize yourself with the default [...]