Bar chart using php

Question

0

Is anybody having idea about bar chart in php.
I need to import the datas from excel sheet into php.
I have created static bar chart.
but i have to create dynamic bar chart .
The datas should be retrieved from mysql or from excel sheet. If anybody knows kindly tell me the solution.

php

3

Contributors

3

Replies

5

Views

7 Years

Discussion Span

7 Years Ago

Last Post by qazplm114477

This Question has been Answered

php

nonshatter 26 · Answer 1 · 2011-02-25T15:20:06+00:00

Hi there, I'd use FusionCharts.

They have great documentation

Your code would be something like this:

<?php
      //We've included ../Includes/FusionCharts.php, which contains functions
      //to help us easily embed the charts.
      include("../Includes/FusionCharts.php");
      ?>
      <HTML>
         <HEAD>
        <TITLE> FusionCharts - Array Example using Single Series Column 3D Chart</TITLE>
        <SCRIPT LANGUAGE="Javascript" SRC="../../FusionCharts/FusionCharts.js"></SCRIPT>
     </HEAD>
     <BODY>
     <?php
         // YOU COULD RETRIEVE DATABASE VALUES, THEN PUT THEM INTO THESE ARRAYS:

         //In this example, we plot a single series chart from data contained
   //in an array. The array will have two columns - first one for data label
   //and the next one for data values.
   //Let's store the sales data for 6 products in our array). We also store
   //the name of products. 
         //Store Name of Products
         $arrData[0][1] = "Product A";
         $arrData[1][1] = "Product B";
         $arrData[2][1] = "Product C";
         $arrData[3][1] = "Product D";
         $arrData[4][1] = "Product E";
         $arrData[5][1] = "Product F";
         //Store sales data
         $arrData[0][2] = 567500;
         $arrData[1][2] = 815300;
         $arrData[2][2] = 556800;
         $arrData[3][2] = 734500;
         $arrData[4][2] = 676800;
         $arrData[5][2] = 648500;
         //Now, we need to convert this data into XML. We convert using string concatenation.
         //Initialize <chart> element
         $strXML = "<chart caption='Sales by Product' numberPrefix='$' formatNumberScale='0'>";
         //Convert data to XML and append
         foreach ($arrData as $arSubData)
         $strXML .= "<set label='" . $arSubData[1] . "' value='" . $arSubData[2] . "' />";
         //Close <chart> element
         $strXML .= "</chart>";
         //Create the chart - Column 3D Chart with data contained in strXML
         echo renderChart("../../FusionCharts/Column3D.swf", "", $strXML, "productSales", 600, 300, false, true);
        ?>
  </BODY>
</HTML>

shenbagam · Answer 2 · 2011-02-28T12:00:32+00:00

Thanks buddy but i need to import data from excel sheet.. Is there any solution for this.

qazplm114477 14 · Answer 3 · 2011-02-28T13:47:37+00:00

maybe try

http://www.ibm.com/developerworks/opensource/library/os-phpexcel/index.html