applications

JavaScript charts in PHP and MySQL with FusionCharts XT – Part 2

by Hrishikesh Choudhari on March 16, 2012 · 5 comments

in Tutorials

This the second part of the FusionCharts XT with PHP series. We will create interactive JavaScript charts using data from a MySQL database with FusionCharts XT. We will make use of the PHP library that is bundled with the FusionCharts Suite.

To recap from the first article in this series, FusionCharts XT is essentially a JavaScript charting library, which renders highly interactive charts in the browser. It takes data in either XML or JSON. To plot a chart using PHP, you need to include the HTML and JavaScript code to embed a chart object and then provide the requisite parameters. To make things simpler for you, we have put all this functionality in a PHP script named FusionCharts.php. This script is bundled in FusionCharts XT Download Package > Code > PHP > Includes > FusionCharts.php. So, whenever you need to work with FusionCharts XT in PHP, just include this file in your page and you’re good to go.
Read the rest of this entry »

Second base with charts: Understanding the Bubble chart

by Sanket Nadhani on August 13, 2009 · 4 comments

in Charting Guidelines

When you have a table with 3 related dimensions of data, how do you represent it on a flat 2D chart? Put three column charts side by side, one for each dimension? Or use two XY-plot charts? But both of them will be ineffective in putting together all the 3 parameters in one elegant visualization. Time to say hello to the bubble chart.

In the third and last post of “Second base with charts”, we will show how bubble charts allow you to compare plotted entities in terms of dissimilar yet related criteria.

Read the rest of this entry »

Second base with charts: Understanding the Multi-level pie chart

August 7, 2009 Charting Guidelines
Second base with charts: Understanding the Multi-level pie chart

Pie charts have been used, misused and abused. But what about the multi-level pie chart? They have been under-used, to put it simply. Other standard charts have been opted for even when the multi-level pie chart would have been the perfect fit.

So in this post of "Second Base with charts", we will explore the multi-level pie chart and see how it can be used to effectively represent hierarchical…

Read the rest of this entry »

Second base with charts: Understanding the Waterfall chart

July 30, 2009 Charting Guidelines
Second base with charts: Understanding the Waterfall chart

Everyone hits the first base. But getting to the second base is where a lot of people are lost out. Yes, almost everyone has made use of simple column, line and pie charts at some point of time in their lives. But when your relationship with data starts heating up, the first base just won’t do.

On that note, we start our foray into second base with charting. In…

Read the rest of this entry »