rmortensen

ok .. I'd get that in a new version as it is a pretty basic charting function ..to change font colors on specific elements of a chart

I'm looking to have different font colors for data values on a column2D chart .. as described in I can not get the syntax of the font attribute to work using XML .. per the example <chart caption="Scale in Points" subcaption="Pointers for 2012" canvasbgcolor="808080" divlinealpha="0" palette="3" yaxisname="Souls"> <set label="Label 1" displayValue="<font style="color:00008B;"">1.0<font>" value="1.0" /> <set label="Label 2" displayValue="<font style="color:FFFFFF;"">2.0<font>" value="2.0" /> <set label="Label 3" displayValue="<font style="color:000000;"">3.0<font>" value="3.0" /> <set label="Label 4" displayValue="<font style="color:FF008B;"">4.0<font>" value="4.0" /> </chart> Can any member help me ? this is exactly what I need to do but I can not get the XML correct .. i believe it has to do with the use of double " in the XML. I can programatically set the display value attribute based on the value .. but i can't get the syntax to work I know I can use annotations, but that solution is way more complex than getting the above to work Any help would be appreciated. Thank You

There was a workaround to that described in the post I referenced to .. why not attempt to help me with the syntax of that instead of constantly referring to annotations ?? some help "out side of the box" would be helpful here

That changes the label color .. I need the color of the value to change

I understand its not available and the annotation option is pretty messy as each chart varies .. I would like to understand if the font tag option outlined in this thread works and if it does what the syntax would be to make it work. I can implement that much easier than the annotation option I would add that as an option in a future version .. it seems that adding a font color option to the set tag would be a valuable addition to the product and many developers would like that as an option when displaying values in a chart again .. does this work and what would the syntax be? <set label="Label 1" displayValue="<font style="color:00008B;"">1.0<font>" value="1.0" />

for example .. the red bars need values displayed in white so you can see them and the yellow and green black page.tiff

Thanks for the reply .. I need to change the color of the displayed value on the chart .. Dark for light background charts, Light for dark background charts. Doing at the chart level will not do that .. it will be effective for the whole chart this thread discusses a way to change the text color for a specific chart label .. but the syntax is incorrect .. it does not work .. using the font style parameter in the set section of the XML is the way I need to do it

I can't get the below syntax to work and none of the examples download correctly .. <set label="Label 1" displayValue="<font style="color:00008B;"">1.0<font>" value="1.0" /> I need to implement this in a colum2D chart .. to vary the font colors there are only 5 quote marks on the displayValue tag.. any help would be appreciated

in Safari 6.01 and Chrome 22.0.1229.94 I am not able to display Chart Captions or Category Titles on the StackedColumn2D.swf (stacked 2d column chart). When I display as Flash they display .. when I display as javascript .. they do not. They display fine in Camino and Firefox here is my XML: <chart animation="0" useRoundEdges="0" showYAxisValues="1" showSum="0" formatNumberScale="0" baseFontSize="12" baseFontColor="000000" caption="Filled to UnFilled" outCnvBaseFontSize="12"> − <categories fontColor="000000" fontSize="12"> <category label="Oct-11"/> <category label="Nov-11"/> <category label="Dec-11"/> <category label="Jan-12"/> <category label="Feb-12"/> <category label="Mar-12"/> <category label="Apr-12"/> <category label="May-12"/> <category label="Jun-12"/> <category label="Jul-12"/> <category label="Aug-12"/> <category label="Sep-12"/> </categories> − <dataset seriesName="Awarded Shifts" color="333399"> <set value="4729" displayValue="56%"/> <set value="4882" displayValue="59%"/> <set value="5261" displayValue="58%"/> <set value="4781" displayValue="57%"/> <set value="4813" displayValue="55%"/> <set value="5450" displayValue="59%"/> <set value="4847" displayValue="55%"/> <set value="6401" displayValue="61%"/> <set value="7120" displayValue="63%"/> <set value="7757" displayValue="64%"/> <set value="8144" displayValue="63%"/> <set value="8303" displayValue="65%"/> </dataset> − <dataset seriesName="Unfilled Shifts" color="33CCFF" showValues="0"> <set value="3722"/> <set value="3356"/> <set value="3750"/> <set value="3680"/> <set value="3938"/> <set value="3793"/> <set value="3908"/> <set value="4019"/> <set value="4154"/> <set value="4384"/> <set value="4704"/> <set value="4448"/> </dataset> </chart> safari.tiff camino.tiff

I'm having the same issue with XT 3.2.2 SR1 .. forcing it to use javascript works fine in 3.2.2 .. except that I needed to force for the MSStackedColumn2D chart which was not available in 3.2.2. If I use 3.2.2 charts display fine forcing javascript. If I use 3.2.2 SR1 none of them do. I'm not running on a local file system. Here is how I'm calling the charts: var URL = "http://.../empreqshifts.php?client="+client+"&hospital="+hospital; URL = escape(URL) </script> </head> <body bgcolor="#ffffff"> <div id="chartdiv"> The chart will appear within this DIV. This text will be replaced by the chart. </div> <script type="text/javascript"> FusionCharts.setCurrentRenderer('javascript'); var myChart = new FusionCharts("http://.../fusion/charts32/MSCombi2D.swf", "myChartId", "1175", "425", "0", "0"); myChart.setDataURL(URL); myChart.setTransparent(true); myChart.render("chartdiv"); </script> </body> u reference in this post using the setDataURL does not work using a local file system .. I'm accessing on a server. If i display as Flash they display fine .. if I force javascript .. all I get is "Loading chart. Please wait"

I have an HTML page that calls a PHP script that reads from MySQL, formats the XML and uses echo to return the XML. All works fine if I hard code the URL but I want to pass variables to the PHP script from the Query String My Code: var client = qsParm['client']; var site = qsParm['site']; var region = qsParm['region']; var calc = qsParm['calc']; var URL = "http://www.marvelit.com/securitas/turnover/turnover.php?client=" + client + "&region=" + region + "&site=" + site + "&calc=" + calc; var myChart = new FusionCharts("http://www.marvelit.com/fusion/charts/AngularGauge.swf", "myChartId", "300", "200", "1", "0"); myChart.setDataURL(URL); myChart.render("chartdiv"); The URL gets built properly - but I can not get it to successfully pass to the PHP script. I used the First Chart as an example. This seems like a basic process - but I can not get it to work. I have tried escape(URL) to encode - but the myChart.setDataURL(URL) does not pass the URL. If I use myChart.setDataURL("http://www.marvelit.com/securitas/turnover/turnover.php?client=") it works but if myChart.setDataURL("http://www.marvelit.com/securitas/turnover/turnover.php?client="+client) does not work I have gone over all the documentation and these forums and have not had any success finding an answer

I'm trying to have a chart with three columns - the first column's values are 1-20k. The second and third columns are 1-100 I want columns - I have been able to get something to work using the MSCombiDY2D.swf - by using the parentYAxis and renderAs tags - but it is bery difficult to get things to line up properly. Is there a way to do this with the Column2D.swf? The parentYAxis tag does not apply to this chart Please advise

Took a quick look - the problem is the left and right columns are off center - and the columns are narrow. The 2D Column chart is what I need - see the following attachment - is the 2D chart with 1 axis. Seems like a reasonable expectation for the product I would add as a possible enhancement

can you post an image for me so I have a reference?

Thanks - I'm using the MSCombiDY2D.swf The XML and chart image are attached xml.txt

I'm trying to add displayValues on my Trendpoints. I am using the displayValue attribute. I want to combine the text with a value received from a database - I do not need help with the DB - but is there a way to combine two values and have it displayed? similar to the concat function in SQL - concat('75th=',$row[Q75]) = display '75th=115' on the chart? I can do one or the other - but not both

I'm using a PHP script to get a value from MySQL to be charted on the Angular Guage. The Chart displays - but it is always at 100%. I put the chart in debug mode and it displays the dataURL correctly. When I click on the URL from the debug screen - it displays: < chart bgColor="FFFFFF" lowerLimit="0" upperLimit="100" upperLimitDisplay="Bad" lowerLimitDisplay="Good" gaugeStartAngle="180" gaugeEndAngle="0" palette="1" numberSuffix="%" tickValueDistance="20" showValue="1" showBorder="0"> < colorRange> < color minvalue="0" maxvalue="50" code="228B22"/> < color minvalue="50" maxvalue="100" code="FF0000"/> < /colorRange> < dials> < dial value="21"rearExtension="10"/> < /dials> < /chart> However the debug screen displays the following XML: < ?xml version="1.0"?> < chart bgColor="FFFFFF" lowerLimit="0" upperLimit="100" upperLimitDisplay="Bad" lowerLimitDisplay="Good" gaugeStartAngle="180" gaugeEndAngle="0" palette="1" numberSuffix="%" tickValueDistance="20" showValue="1" showBorder="0"> < colorRange> < color minvalue="0" maxvalue="50" code="228B22" /> < color minvalue="50" maxvalue="100" code="FF0000" /> < /colorRange> < dials> < dial value="" rearExtension="10" /> < /dials> < /chart> and the following message: Invalid data: Invalid number specified in XML. FusionCharts can accept number in pure numerical form only. If your number formatting (thousand and decimal separator) is different, please specify so in XML. Also, do not add any currency symbols or other signs to the numbers. Why would this occur - clicking on the URL looks like it retrieves valid XML with a value - but the XML in the debug window shows no value - hence the error and the chart displaying 100% code is attached - turnover.html displays the chart and calls turnover.php

I'm using a PHP script to get a value from MySQL to be charted on the Angular Guage. The Chart displays - but it is always at 100%. I put the chart in debug mode and it displays the dataURL correctly. When I click on the URL from the debug screen - it displays: < chart bgColor="FFFFFF" lowerLimit="0" upperLimit="100" upperLimitDisplay="Bad" lowerLimitDisplay="Good" gaugeStartAngle="180" gaugeEndAngle="0" palette="1" numberSuffix="%" tickValueDistance="20" showValue="1" showBorder="0"> < colorRange> < color minvalue="0" maxvalue="50" code="228B22"/> < color minvalue="50" maxvalue="100" code="FF0000"/> < /colorRange> < dials> < dial value="21"rearExtension="10"/> < /dials> < /chart> However the debug screen displays the following XML: < ?xml version="1.0"?> < chart bgColor="FFFFFF" lowerLimit="0" upperLimit="100" upperLimitDisplay="Bad" lowerLimitDisplay="Good" gaugeStartAngle="180" gaugeEndAngle="0" palette="1" numberSuffix="%" tickValueDistance="20" showValue="1" showBorder="0"> < colorRange> < color minvalue="0" maxvalue="50" code="228B22" /> < color minvalue="50" maxvalue="100" code="FF0000" /> < /colorRange> < dials> < dial value="" rearExtension="10" /> < /dials> < /chart> and the following message: Invalid data: Invalid number specified in XML. FusionCharts can accept number in pure numerical form only. If your number formatting (thousand and decimal separator) is different, please specify so in XML. Also, do not add any currency symbols or other signs to the numbers. Why would this occur - clicking on the URL looks like it retrieves valid XML with a value - but the XML in the debug window shows no value - hence the error and the chart displaying 100% code is attached - turnover.html displays the chart and calls turnover.php

figured it out - My variables in the query string could contain '%' - the wild card character for ALL. Evidently the escape() encodes it - but for some reason the GET in the PHP script was not decoding it - or was incorrectly. I tried a number of different routines - but none would work correctly - so I added a bit of JS code to the calling HTML page: if(site == '%') { site = 'ALL' }; Than on the other side - I use a case statement in the where clause looking for 'ALL' and replacing with '%' - ..... and case when '".$site."' = 'ALL' then SCOUNT.SITEID like '%' else SCOUNT.SITEID = '".$site."' end ..... not the best solution but it works. Is there a suggested way to decode special characters in PHP to get around this?

figured it out - My variables in the query string could contain '%' - the wild card character for ALL. Evidently the escape() encodes it - but for some reason the GET in the PHP script was not decoding it - or was incorrectly. I tried a number of different routines - but none would work correctly - so I added a bit of JS code to the calling HTML page: if(site == '%') { site = 'ALL' }; Than on the other side - I use a case statement in the where clause looking for 'ALL' and replacing with '%' - ..... and case when '".$site."' = 'ALL' then SCOUNT.SITEID like '%' else SCOUNT.SITEID = '".$site."' end ..... not the best solution but it works. Is there a suggested way to decode special characters in PHP to get around this?

I figured this out - I was passing the variables within ' ' - after I removed them - it is passing the URL variable now