Member Avatar for shenbagam

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.

  • 3 Contributors
  • 3 Replies
  • 533 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by qazplm114477

Recommended Answers

All 3 Replies

Member Avatar for nonshatter

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>
Edited by nonshatter because: n/a
Member Avatar for shenbagam

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.