![](https://forum.fusioncharts.com/uploads/set_resources_2/84c1e40ea0e759e3f1505eb1788ddf3c_default_photo.png)
Jamie 1
Members-
Content count
31 -
Joined
-
Last visited
About Jamie 1
-
Rank
Advanced Member
-
Thank you Akash. That was exactly what I was looking for. Many thanks.
-
Hello. I would like to add an image above each column in my chart. So the image will represent the data in the column. I think I saw something about this once but cannot find it now. Any help please? Jamie
-
Jamie 1 started following Angle Gauge Limits
-
Hello. I am making a gauge to show if we are ahead or behind our schedule. Hence the gauge needs to swing from -60 mins to +60 mins, with '0' at the centre. Problem. I have the Lower Value set at -60 and it needs to stay there so the gauge looks level. BUT upon update the Lower Limit always increases the lower limit. This happens regardless of the updated value. So if the updated value is +14, it still changes the Lower Limit. See picture. How can I stop it changing its self please? Jamie $Schedule = array( "chart" => array( "caption" => $schedule_main[0]['n1'], "showValue" => "1", "valueBelowPivot" => "1", "majorTMNumber" => "4", "minorTMNumber" => "4", "gaugeFillMix" => "{dark-30},{light-60},{dark-10}", "gaugeOuterRadius" => "100%", "gaugeInnerRadius" => "60%", "minValue" => "-60", "theme" => "fint" ) ); $colorRange = array( "color" => array( array( "minValue" => "-60", "maxValue" => $schedule_main[0]['t2'], "code" => $schedule_main[0]['colourL'] ), array( "minValue" => $schedule_main[0]['t2'], "maxValue" => $schedule_main[0]['t1'], "code" => $schedule_main[0]['colourM'] ), array( "minValue" => $schedule_main[0]['t1'], "maxValue" => $schedule_main[0]['tmax'], "code" => $schedule_main[0]['colourH'] ) ) );
-
Prerana. One problem I have with the sample code. It seems I have to manually write each year in the code. $arrDataMonth[2011]["linkeddata"] = array(); $arrDataMonth[2012]["linkeddata"] = array(); How do I get this to list the years automatically please? // data for linked chart will start from here, SQL query from quarterly_sales table $year = 2011; $strQuarterly = "SELECT Quarter, (Sales * 20) as Sales , Year FROM quarterly_sales WHERE 1"; $resultQuarterly = $dbhandle->query($strQuarterly) or exit("Error code ({$dbhandle->errno}): {$dbhandle->error}"); // if the query returns a valid response, preparing the associative JSON array for child chart if ($resultQuarterly) { $arrData["linkeddata"] = array(); // `linkeddata` is responsible for feeding data and chart options to child charts. $arrDataMonth[2011]["linkeddata"] = array(); $arrDataMonth[2012]["linkeddata"] = array(); $arrDataMonth[2013]["linkeddata"] = array(); $arrDataMonth[2014]["linkeddata"] = array(); $arrDataMonth[2015]["linkeddata"] = array(); $arrDataMonth[2016]["linkeddata"] = array(); $i = 0; if ($resultQuarterly) { while ($row = mysqli_fetch_array($resultQuarterly)) { // collect the year for which quarterly drilldown will be created $year = $row['Year']; // create the monthly drilldown data $arrMonthHeader[$year][$row["Quarter"]] = array(); $arrMonthData[$year][$row["Quarter"]] = array();
-
Thank you Prerana. That has massively helped me. I still need to figure out some parts but hopefully I should be ok now. Thanks again. Jamie. ps. Any idea when Fusioncharts Play will be available?
-
Hello. This has me stumped for several days. I need a drill down chart to open to another chart on the same page. I can't find anything to help with this. I am drawing from MySql. I have it working but only drilling in the same chart. It needs to go to another div. The child data is from a php file as shown below. What changes do I need to do to drill to another div please? Thanks. Jamie. <body> <?php // Form the SQL query that returns the top 10 most populous countries $strQuery = "SELECT a.areaname as Name, a.areaid as Population, a.areaid as Code FROM area a ORDER BY Population DESC LIMIT 10"; // Execute the query, or else return the error message. $result = $dbhandle->query($strQuery) or exit("Error code ({$dbhandle->errno}): {$dbhandle->error}"); // If the query returns a valid response, prepare the JSON string if ($result) { // The `$arrData` array holds the chart attributes and data $arrData = array( "chart" => array( "caption" => "Top 10 Most Populous Countries", "showValues"=> "0", "theme"=> "zune" ) ); $arrData["data"] = array(); // Push the data into the array while($row = mysqli_fetch_array($result)) { array_push($arrData["data"], array( "label" => $row["Name"], "value" => $row["Population"], "link" => "drillchild1.php?Country=".$row["Code"] ) ); } /*JSON Encode the data to retrieve the string containing the JSON representation of the data in the array. */ $jsonEncodedData = json_encode($arrData); /*Create an object for the column chart. Initialize this object using the FusionCharts PHP class constructor. The constructor is used to initialize the chart type, chart id, width, height, the div id of the chart container, the data format, and the data source. */ $columnChart = new FusionCharts("column2D", "myFirstChart" , 600, 300, "chart-1", "json", $jsonEncodedData); // Render the chart $columnChart->render(); // Close the database connection $dbhandle->close(); } ?> <div id="chart-1"><!-- Fusion Charts will render here--></div> </body>
-
Thanks again Prerana. Could you simplify this to have the colour range within the php page, not from the database please? I'm trying to convert from the old flash version of FC. Thanks. Jamie.
-
Thank you very much Prerana. That got me going. Can you explain how the colours work please? I can't get any colours across the gauge. I think it's something to do with the $code attribute? Jamie.
-
Thanks. I have been through those tutorials but it is different for the Angular Gauge. Do you have an example for this please?
-
Hello. I've been trying all day to do this. Do you have an example of an Angulargauge, getting it's data in XML, dynamically from a database please? Thanks . Jamie.
-
Thanks for the reply. Yes that works ok in the JS Fiddle, but I am using the older Flash charts. As you can see from the photo the x-axis is negative, but the bars go upwards, not downwards from zero. This makes the chart inaccurate. Is there a way in the flash charts to fix this please? Jamie.
-
Hello. My chart data sometimes returns as a -ve value, which is correct. Sometimes Fusioncharts displays the -ve values with an inverted bar, which is correct, but sometimes it displays like a +ve value. See Photo. Is there a way to ensure that -ve values have inverted bars please? Jamie.
-
It's ok I found the problem. I needed this in the code ---- highColor='00CC33' lowColor='CC0000' Thanks anyway.
-
I don't really want to pay again for the latest version just to get this feature working. I think it's more likely my code. Can you please check the code I attached? Thanks.
-
Hello. I have the older Flash version of Widgets. I am trying to get a SparkColumn to show the Highest value id green and the lowest value in red (the same as your examples). All of my values are grey. Can you help please? Thankyou. Jamie.