Google Charts : Understanding

We will follow 6 steps to understand our code to draw the chart.
  1. Load the library
  2. Prepare data in the required format
  3. Set the options of the chart
  4. Instantiate the chart class
  5. Set any event listener ( optional )
  6. Draw the chart

Load the library

The library is hosted by google. We need to one time call this library even we have multiple charts in the same page. This is how we will link to the loader library.
<script src=""></script>

Preparing data

To display the chart different types of data tables are used. For Pie chart and Bar chart two column tables are used.

Number of tutorials at
We can collect data from MySQL table by using PHP and then match the input data format required for Chart. We can use any Backend script and we just require to match the required format to display the charts.

Data from MySQL is used to create Pie chart

Chart requires data in a particular format to prepare the chart . Here it is .
          ['PHP', 300],
          ['MySQL', 100],
          ['JavaScript', 200],
          ['JQuery', 200],
          ['HTML', 200],
          ['ASP', 100]
We can use a two dimensional array in JavaScript to give this input data.
var tutorials = [['PHP', 300],['MySQL', 100],['JavaScript', 200],
We will match the required format by displaying the array elements.
for(i = 0; i < tutorials.length; i++)
    data.addRow([tutorials[i][0], tutorials[i][1]]);

Why through array ?

We declared the array as global variable and used the same to display the chart. The array we create can be created by using data from any database ( say MySQL) or by reading a csv file or by using Json string or from user input fields.
Demo of Redrawing chart with user inputs
We can modify data stored inside the array and change the chart dynamically by modifying the array data.
Pie Chart using array of data

Options of the chart

Options can be added to chart, here based on the chart type we can set different options. Here are some common options.
var options = {'title':'plus2net',

Instantiate the chart class

In our HTML part we kept one div tag with id='chart_div'. We get a handler and using this we will pass the data and options.
var chart=new google.charts.Bar(document.getElementById('chart_div'));

Set any event listener ( optional )

On click or select of any element of the chart we will display more details. This part we will try separately by using a demo script.
Adding Event Listener to Chart

Draw the chart

var chart=new google.charts.Bar(document.getElementById('chart_div'));
chart.draw(data, options);
We passed data and options to our Chart by using the handler.

Let us check some popular types of chart we can develop.

Area Chart

Area Chart Area with dynamic data

Column Chart

Column Chart With Data from MySQL table

Donut Chart

Donut Chart With Data from MySQL table

Line Chart

Line Chart With Data from MySQL table
Chart Column with dynamic data Chart Column with MySQL database data Charts MySQL data as Pie Chart Tutorial on using MySQL records to display in Google table chart.
Subscribe to our YouTube Channel here


* indicates required
Subscribe to plus2net

    Post your comments , suggestion , error , requirements etc here

    We use cookies to improve your browsing experience. . Learn more
    HTML MySQL PHP JavaScript ASP Photoshop Articles FORUM . Contact us
    ©2000-2022 All rights reserved worldwide Privacy Policy Disclaimer