jwcrosby

Members
 View Profile  See their activity

  • Content count

    16

  • Joined

  • Last visited

Everything posted by jwcrosby

  1. My scatter chart is working fine (using PHP Class), but I've noticed that if I have duplicate x-y value sets, like having two sets with the value "4,6", the resultant scatter chart doesn't indicate there are two sets of data represented by the single point on the chart. When I hover over the point, it shows the value of only one of the sets, randomly chosen at that, I believe. Is there a way I could indicate to the viewer that duplicate sets exist when this occurs? Thanks in advance. Jerry
  2. I'm using a scatter chart with PHP Class and it's working fine, except for one thing. In my data, the maximum value of the x value is 12 and the maximum value of the y value is also 12. I want the chart to scale out with the full zero to 12 for x and zero to 12 for y, regardless of the actual x,y values in the particular data set. In other words, if the data set were to only have one plot, say (3,4), I want the chart to still show "potential" maximum x & y values of 12. I thought I had accomplished this with the following code for categories: $FC->addCategory("2","x=2;showVerticalLine=1"); $FC->addCategory("4","x=4;showVerticalLine=1"); $FC->addCategory("6","x=6;showVerticalLine=1"); $FC->addCategory("8","x=8;showVerticalLine=1"); $FC->addCategory("10","x=10;showVerticalLine=1"); $FC->addCategory("12","x=12;showVerticalLine=1"); I thought this would force the chart to have vertical lines at the 2, 4, 6, 8, 10 & 12 values, regardless of the actual data. But it doesn't all the time. If the data set happens to have some higher x or y values, it will, but if not, the chart shows a "smaller" chart. I don't want that. Ideas on what I should do? (Please feel free to ask me questions for clarification; I fear I have not explained this very well.) Jerry

  3. Scatter chart not showing all categories

    jwcrosby replied to jwcrosby's topic in FusionCharts and PHP

    I figured it out: had to use yAxisMaxValue and xAxisMaxValue in the $strParam= line and set them both = to 12. Got me what I wanted! Jerry
  4. The following code is working properly in Firefox, but not in IE. It's built on the template that came with the documentation. I've stripped out some lines of unnecessary stuff to shorten it. It uses PHP Class. What I get in IE is just a blank space where the chart should be. Here's the code: <? include("fusion_charts/Code/PHPClass/Includes/FusionCharts_Gen.php"); include("fusion_charts/Code/PHPClass/Includes/DBConn.php"); ?> <HTML> <HEAD> <TITLE>Plot of All Communities</TITLE> <SCRIPT LANGUAGE="Javascript" SRC="fusion_charts/Code/FusionCharts/FusionCharts.js"></SCRIPT> </HEAD> <BODY> <CENTER> <h2>Plot of Community & Church Development (all)</h2> <? // Connect to the Database $link = connectToDB(); # Create Scatter chart object using FusionCharts PHP Class $FC = new FusionCharts("Scatter","650","450"); # Set Relative Path of swf file. $FC->setSWFPath("fusion_charts/Charts/"); # Define chart attributes $strParam="yAxisName=Community Development;xAxisName=Church Development"; # Set chart attributes $FC->setChartParams($strParam); # Add Category, 1st parameter take label and 2nd parameter takes x axis value # as parameter list $FC->addCategory("2","x=2;showVerticalLine=1"); $FC->addCategory("4","x=4;showVerticalLine=1"); $FC->addCategory("6","x=6;showVerticalLine=1"); $FC->addCategory("8","x=8;showVerticalLine=1"); # Add a new dataset - this produces the legend $FC->addDataSet("All Users","color='0000FF' anchorSides='4' anchorRadius='4' anchorBgColor='C6C6FF' anchorBorderColor='0000FF'"); // Fetch data using SQL Query $strQuery = "SELECT church_development, community_development FROM tblcommunities;"; $result = mysql_query($strQuery) or die(mysql_error()); $num=mysql_numrows($result); $i=0; while ($i < $num) { $church=mysql_result($result,$i,"church_development"); $community=mysql_result($result,$i,"community_development"); #add data to data chart $FC->addChartData($church,"y=".$community); $i++; } mysql_close($link); # Render the chart $FC->renderChart(); ?></CENTER> </BODY> </HTML> Can anyone see my problem? Thanks in advance for any help. Jerry

  5. Visible in Firefox, but not in IE

    jwcrosby replied to jwcrosby's topic in Javascript Problems

    I believe I've located the problem. I copied over the FusionCharts.js and FusionCharts_Gen.php files that you just sent onto my server one-by-one and when I used your copy of FusionCharts.js it worked. I noticed a slight difference in the creation dates on the two versions of that file and that made me suspicious. Was it something I had done to that .js file? I can't recall ever doing anything there, but perhaps I did. Thanks again. Jerry

  6. Visible in Firefox, but not in IE

    jwcrosby replied to jwcrosby's topic in Javascript Problems

    I can see that one!!! Yeah! I'll delve into the code to find where the difference is, but I'm sure you could tell me and save some time. I look forward to hearing from you. Thanks. Jerry

  7. Visible in Firefox, but not in IE

    jwcrosby replied to jwcrosby's topic in Javascript Problems

    [insert opening PHP tag] # Render Chart $FC->renderChart(); [insert closing PHP tag]

  8. Visible in Firefox, but not in IE

    jwcrosby replied to jwcrosby's topic in Javascript Problems

    I have uninstalled and re-installed Flash v. 10 and still no success. When I right-click on the white space the box shows "movie not loaded" greyed/faded out and "About Adobe Flash Player 10..." in bold. Jerry

  9. Visible in Firefox, but not in IE

    jwcrosby replied to jwcrosby's topic in Javascript Problems

    First of all, Rahul, thanks for fixing the code in my post! Looks much better! I've tried viewing the file on 3 different computers, all with the same results. All are running Version 9 of Flash. On the computer I am currently at, I do not find that uninstall_activex.exe file. What I do see in that folder is uninstall_plugin.exe and UninstlFl.exe. However, I do see Macromedia Flash 8 and Flash 8 Player listed in "add/remove programs" on the control panel. Suggestions of what to do? Thanks. Jerry

  10. Visible in Firefox, but not in IE

    jwcrosby replied to jwcrosby's topic in Javascript Problems

    Sorry that code looks so bad. I used the as requested, but must have done it incorrectly. Jerry
  11. I've been working with the BasicDBExample.php file in the PHP Class folder and I can successfully draw data from my database and draw most charts. But I can't get it to work with the Scatter.swf chart. The data I'm pulling are two fields, each with numbers in them. The line below, from the example file, passes those values to the chart: $FC->addDataFromDatabase($result, "engel", "peter"); The values in the engel and peter fields vary from zero to 12, all positive. When I run the page I can see the scatter chart, but no data is plotted--it's empty. If I change the chart spec to Pie3D.swf, or Bar2d.swf I get pie sections and bars to show up. I haven't been able to find any helpful tutorial for how to spec out a scatter chart properly. Thanks in advance for any help given. Jerry

  12. getting the scatter plot to work using PHP Class

    jwcrosby replied to FusionCharts Support's topic in FusionCharts and PHP

    I have further studied the FusionCharts_Gen.php file and it appears it has what it needs to populate a scatter graph, but I'm too new to this to clearly see what to do. What function would I use in place of AddDataFromDatabase to generate the XML for a scatter plot? And what would the parameters be? Thanks for any help. Jerry

  13. getting the scatter plot to work using PHP Class

    jwcrosby replied to FusionCharts Support's topic in FusionCharts and PHP

    Are you saying that it's just this particular function (AddDatatoDatabase) that won't work with a scatter plot? If so, is there a way I could make use of the other functions and populate a scatter chart from a different angle? Jerry

  14. giving me fits

    jwcrosby posted a topic in FusionCharts and PHP

    I'm working with the example for "Plotting from Database." I understand what it is trying to do when accessing the sample Factory records. However, the building of the $strXML variable doesn't seem to be working for me, even though I've copied the code directly from the example. I've narrowed the problem down to the < and > characters in the code. For example, the code line in the documentation below will not echo anything: $strXML = ""; If I remove the < and > it will echo the string. I have fussed with the single and double quotation marks, and even tried using chr(60) and chr(62), but to no avail. Does anyone have an idea of why I am not getting the final string? Because it's producing nothing, there is nothing to pass to the renderChart function and thus no chart is shown. Thanks in advance. Jerry

  15. giving me fits

    jwcrosby replied to jwcrosby's topic in FusionCharts and PHP

    Thanks for the reply, Rahul. I've worked on this some more and landed on using the PHP Class module and it's working fine. I can understand that approach better. My original problem may have been the pointer to the location of the SWF file was incorrect. Guess that doesn't matter because I have it working now. Thanks again. Jerry

  16. giving me fits

    jwcrosby replied to jwcrosby's topic in FusionCharts and PHP

    I see that in my message the string from the example file doesn't even appear here. It should be: $strXML = "[character here]graph caption='Factory Output report' subCaption='By Quantity' decimalPrecision='0' showNames='1' numberSuffix=' Units' pieSliceDepth='30' formatNumberScale='0'[character here]"; I have substituted "[character here]" for the less than and the greater than characters, hoping it would show up here. Jerry