MartinS

Thanks. So are you saying that the approach I have taken is not the best one and I would be better using a different method? If so, I am a little confused as to how I should change my code to use RenderChart? I did try that, but it gave me different output, which I guess means that it will not work with a literal control? I'd like to know what changes I need to make to work with the RenderChart method? Thanks again Martin

Not an ideal solution, but as I cannot wait for a response as the work is extremely urgent, I have implemented the following: // get xml for chart... string xmlFusion = FusionCharts.RenderChartHTML( fullPathSwf = "/CustomControls/ResultsGraphPanel/Charts/MSColumn2D.swf", string.Empty, xmlChartString, "MyFusion_Chart", "650", "350", false, true, true); // strip out any odd character implementations... xmlFusion = xmlFusion.Replace("%2525", "%25"); xmlFusion = xmlFusion.Replace("%2526", "%26"); xmlFusion = xmlFusion.Replace("%252f", "%2f"); If I'm missing something that avoids me having to do this, then please let me know. Martin

Hi Yes, as I stated above, we are using renderChartHTML to generate the chart Xml. I assume I am already encoding the special characters? What is the difference when switching to renderChart? Currently the output from RenderChartHTML is loaded into a literal control and displayed - will this still work with renderChart? Here are the parameters i am using in RenderChartHTML: fullPathSwf = "/CustomControls/ResultsGraphPanel/Charts/MSColumn2D.swf", string.Empty, xmlChartString = see below, "MyFusion_Chart", "650", "350", false, true, true) This is the code it generates: <!-- START Code Block for Chart FusionChart_Chart --> <object id="FusionChart_Chart" classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" height="350" width="650" codebase="http://fpdownload.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=8,0,0,0" > <param name="movie" value="/CustomControls/ResultsGraphPanel/Charts/MSColumn2D.swf"> <param name="FlashVars" value="&registerWithJS=1&chartHeight=350&DOMId=FusionChart_Chart&dataXML=<chart animation='1' bgAlpha='0,0' showBorder='0' useRoundEdges='1' setAdaptiveYMin='1' numberScaleValue='1000,1000,1000' numberScaleUnit='K,M,B' caption='LGPT 2010 Base (23) 5%266 0.5' xAxisName='' yAxisName='' anchorAlpha='01' anchorBgAlpha='01' showValues='0' showLegend='1' legendBorderAlpha='0' legendBgAlpha='0' legendPosition='Bottom' legendShadow='0' labelDisplay='Wrap' decimals='2' forceDecimals='1' exportEnabled='1' exportAtClient='1' exportHandler='fcExporter' exportFileName='15072011_LGPT2010Base235605_Chart' toolTipBgColor='FFFFFF'toolTipBorderColor='FFFFFF'><categories><category label='2011'/><category label='2012'/><category label='2013'/><category label='2014'/><category label='2015'/><category label='2016'/><category label='2017'/><category label='2018'/><category label='2019'/><category label='2020'/></categories><dataset seriesName='Net+benefit+expense++(IAS19+2008)' alpha='100' includeInLegend='1' color='5074D1' showValues='0' ><set value='-1966.42' tooltext='Net+benefit+expense++(IAS19+2008), -1966.42' link='j-SetClickedGraphDataId-ctl00_MainContent_hidClickedGraphDataStore,ctl00_MainContent_btnDrillDownHandler,0,0' /><set value='-2159.43' tooltext='Net+benefit+expense++(IAS19+2008), -2159.43' link='j-SetClickedGraphDataId-ctl00_MainContent_hidClickedGraphDataStore,ctl00_MainContent_btnDrillDownHandler,0,1' /><set value='-1099.64' tooltext='Net+benefit+expense++(IAS19+2008), -1099.64' link='j-SetClickedGraphDataId-ctl00_MainContent_hidClickedGraphDataStore,ctl00_MainContent_btnDrillDownHandler,0,2' /><set value='-1192.66' tooltext='Net+benefit+expense++(IAS19+2008), -1192.66' link='j-SetClickedGraphDataId-ctl00_MainContent_hidClickedGraphDataStore,ctl00_MainContent_btnDrillDownHandler,0,3' /><set value='-1296.61' tooltext='Net+benefit+expense++(IAS19+2008), -1296.61' link='j-SetClickedGraphDataId-ctl00_MainContent_hidClickedGraphDataStore,ctl00_MainContent_btnDrillDownHandler,0,4' /><set value='-1412.54' tooltext='Net+benefit+expense++(IAS19+2008), -1412.54' link='j-SetClickedGraphDataId-ctl00_MainContent_hidClickedGraphDataStore,ctl00_MainContent_btnDrillDownHandler,0,5' /><set value='-1541.56' tooltext='Net+benefit+expense++(IAS19+2008), -1541.56' link='j-SetClickedGraphDataId-ctl00_MainContent_hidClickedGraphDataStore,ctl00_MainContent_btnDrillDownHandler,0,6' /><set value='-1684.92' tooltext='Net+benefit+expense++(IAS19+2008), -1684.92' link='j-SetClickedGraphDataId-ctl00_MainContent_hidClickedGraphDataStore,ctl00_MainContent_btnDrillDownHandler,0,7' /><set value='-1843.95' tooltext='Net+benefit+expense++(IAS19+2008), -1843.95' link='j-SetClickedGraphDataId-ctl00_MainContent_hidClickedGraphDataStore,ctl00_MainContent_btnDrillDownHandler,0,8' /><set value='-2020.09' tooltext='Net+benefit+expense++(IAS19+2008), -2020.09' link='j-SetClickedGraphDataId-ctl00_MainContent_hidClickedGraphDataStore,ctl00_MainContent_btnDrillDownHandler,0,9' /></dataset><styles><definition><style name='myCaptionFont' type='font' font='Arial' size='16' color='000000' /><style name='myXAxisTitlesFont' type='font' font='Arial' size='13' color='000000' bold='0' /><style name='myYAxisTitlesFont' type='font' font='Arial' size='13' color='000000' bold='0' /><style name='myYAxisValuesFont' type='font' font='Arial' color='000000' bold='0' /><style name='myDataLabelsFont' type='font' font='Arial' color='000000' bold='0' /><style name='myDataValuesFont' type='font' font='Arial' color='000000' bold='0' /><style name='myToolTipFont' type='font' font='Arial' color='000000' bold='0' /></definition><application><apply toObject='CAPTION' styles='myCaptionFont' /><apply toObject='XAXISNAME' styles='myXAxisTitlesFont' /><apply toObject='YAXISNAME' styles='myYAxisTitlesFont' /><apply toObject='YAXISVALUES' styles='myYAxisValuesFont' /><apply toObject='DATALABELS' styles='myDataLabelsFont' /><apply toObject='DATAVALUES' styles='myDataValuesFont' /><apply toObject='TOOLTIP' styles='myToolTipFont' /></application></styles></chart>〈=EN&scaleMode=noScale&chartWidth=650&debugMode=0"> <param name="wMode" value="transparent"> <param name="allowScriptAccess" value="always"> <param name="quality" value="best"> <param name="scaleMode" value="noScale"> <embed src="/CustomControls/ResultsGraphPanel/Charts/MSColumn2D.swf" pluginspage="http://www.macromedia.com/go/getflashplayer" width="650" type="application/x-shockwave-flash" wMode="transparent" id="FusionChart_Chart" scaleMode="noScale" quality="best" flashvars="&registerWithJS=1&chartHeight=350&DOMId=FusionChart_Chart&dataXML=<chart animation='1' bgAlpha='0,0' showBorder='0' useRoundEdges='1' setAdaptiveYMin='1' numberScaleValue='1000,1000,1000' numberScaleUnit='K,M,B' caption='LGPT 2010 Base (23) 5%266 0.5' xAxisName='' yAxisName='' anchorAlpha='01' anchorBgAlpha='01' showValues='0' showLegend='1' legendBorderAlpha='0' legendBgAlpha='0' legendPosition='Bottom' legendShadow='0' labelDisplay='Wrap' decimals='2' forceDecimals='1' exportEnabled='1' exportAtClient='1' exportHandler='fcExporter' exportFileName='15072011_LGPT2010Base235605_Chart' toolTipBgColor='FFFFFF'toolTipBorderColor='FFFFFF'><categories><category label='2011'/><category label='2012'/><category label='2013'/><category label='2014'/><category label='2015'/><category label='2016'/><category label='2017'/><category label='2018'/><category label='2019'/><category label='2020'/></categories><dataset seriesName='Net+benefit+expense++(IAS19+2008)' alpha='100' includeInLegend='1' color='5074D1' showValues='0' ><set value='-1966.42' tooltext='Net+benefit+expense++(IAS19+2008), -1966.42' link='j-SetClickedGraphDataId-ctl00_MainContent_hidClickedGraphDataStore,ctl00_MainContent_btnDrillDownHandler,0,0' /><set value='-2159.43' tooltext='Net+benefit+expense++(IAS19+2008), -2159.43' link='j-SetClickedGraphDataId-ctl00_MainContent_hidClickedGraphDataStore,ctl00_MainContent_btnDrillDownHandler,0,1' /><set value='-1099.64' tooltext='Net+benefit+expense++(IAS19+2008), -1099.64' link='j-SetClickedGraphDataId-ctl00_MainContent_hidClickedGraphDataStore,ctl00_MainContent_btnDrillDownHandler,0,2' /><set value='-1192.66' tooltext='Net+benefit+expense++(IAS19+2008), -1192.66' link='j-SetClickedGraphDataId-ctl00_MainContent_hidClickedGraphDataStore,ctl00_MainContent_btnDrillDownHandler,0,3' /><set value='-1296.61' tooltext='Net+benefit+expense++(IAS19+2008), -1296.61' link='j-SetClickedGraphDataId-ctl00_MainContent_hidClickedGraphDataStore,ctl00_MainContent_btnDrillDownHandler,0,4' /><set value='-1412.54' tooltext='Net+benefit+expense++(IAS19+2008), -1412.54' link='j-SetClickedGraphDataId-ctl00_MainContent_hidClickedGraphDataStore,ctl00_MainContent_btnDrillDownHandler,0,5' /><set value='-1541.56' tooltext='Net+benefit+expense++(IAS19+2008), -1541.56' link='j-SetClickedGraphDataId-ctl00_MainContent_hidClickedGraphDataStore,ctl00_MainContent_btnDrillDownHandler,0,6' /><set value='-1684.92' tooltext='Net+benefit+expense++(IAS19+2008), -1684.92' link='j-SetClickedGraphDataId-ctl00_MainContent_hidClickedGraphDataStore,ctl00_MainContent_btnDrillDownHandler,0,7' /><set value='-1843.95' tooltext='Net+benefit+expense++(IAS19+2008), -1843.95' link='j-SetClickedGraphDataId-ctl00_MainContent_hidClickedGraphDataStore,ctl00_MainContent_btnDrillDownHandler,0,8' /><set value='-2020.09' tooltext='Net+benefit+expense++(IAS19+2008), -2020.09' link='j-SetClickedGraphDataId-ctl00_MainContent_hidClickedGraphDataStore,ctl00_MainContent_btnDrillDownHandler,0,9' /></dataset><styles><definition><style name='myCaptionFont' type='font' font='Arial' size='16' color='000000' /><style name='myXAxisTitlesFont' type='font' font='Arial' size='13' color='000000' bold='0' /><style name='myYAxisTitlesFont' type='font' font='Arial' size='13' color='000000' bold='0' /><style name='myYAxisValuesFont' type='font' font='Arial' color='000000' bold='0' /><style name='myDataLabelsFont' type='font' font='Arial' color='000000' bold='0' /><style name='myDataValuesFont' type='font' font='Arial' color='000000' bold='0' /><style name='myToolTipFont' type='font' font='Arial' color='000000' bold='0' /></definition><application><apply toObject='CAPTION' styles='myCaptionFont' /><apply toObject='XAXISNAME' styles='myXAxisTitlesFont' /><apply toObject='YAXISNAME' styles='myYAxisTitlesFont' /><apply toObject='YAXISVALUES' styles='myYAxisValuesFont' /><apply toObject='DATALABELS' styles='myDataLabelsFont' /><apply toObject='DATAVALUES' styles='myDataValuesFont' /><apply toObject='TOOLTIP' styles='myToolTipFont' /></application></styles></chart>〈=EN&scaleMode=noScale&chartWidth=650&debugMode=0" allowScriptAccess="always" height="350" /> </object> <!-- END Code Block for Chart FusionChart_Chart --> If you need anything else, please shout. Martin

I have spent most of this afternoon trying to get my chart to show & and / in the legend text, and everytime I draw the chart, i cannot get it to display as I expect. For the ampersand, as an example, I have a chart title which conatins an &, and also the legend text contains one too. My solution was, prior to calling FusionCharts.RenderChartHTML, I do the following: // if ampersand not added by code... if (!xmlChartString.Contains("%25")) { // replace ampersand with html character... xmlChartString = xmlChartString.Replace("%", "%25"); } // if ampersand not added by code... if (!xmlChartString.Contains("%26")) { // replace ampersand with html character... xmlChartString = xmlChartString.Replace("&", "%26"); } Example title text of 'Some text 5&6 Summer' displays correctly as 'Some text 5&6 Summer' In the Xml that is rendered, the & has been converted to 5%266, which translates to 5&6 as expected. Example series name text is 'P&L expense (New)', which displays in both the legend and the hover text as 'P%26L expense (New)'. The underlying xml is showing 'P%2526L+expense+(New)'. I also have an example where my the series name text is 'Gains/losses', yet that displays as 'Gains%2flosses' in the legend and hover text, and 'Gains%252flosses' in the xml. Can you tell me how I can ensure that the text is consistent in all aspects of the chart. This has become an urgent issue now and would be good to find a resolution quickly. Many thanks Martin

Thought there may also be another way to do it that I hadn't thought of, but never mind. Thanks anyway Martin

OK, I'll try and explain this as best I can. I have a line chart, and to this I have C# code which loops through adding series data based on data read from a variety of database tables. I also need to add a number of single data points at positions along the chart that are not linked to any of the existing lines. As a brief description of the chart, the x axis is an array of dates, and the y is values. To add the single data points, I currently then add a single series for each point and add these to the series for the lines. Each series has only one data point, but the data point is highlighted as, say, a black triangle for each series. For this reason, these series can't be included in the legend, but I was wondering if it is possible to group a number of series into one, and show the group on the legend. As you can see, I have two sets of series to add, one that shows as a black diamond, the other as a red triangle. I currently have the interactive legend working for the lines, but have added these red and black series as not included in the legend. Is there a way to do what I want and group them? Thanks Martin

Can anyone help?

I have a stacked bar chart on my page, and if I use tab, it cycles through the controls on the page, and includes (but not always) each series in my stacked bars. Is it possible to exclude the chart object and/or series from the tab order? Thanks Martin

Thanks - I ran the uninstaller and re-installed it via the download manager, and all is OK now. Thanks again Martin

Hi I'm still having problems with the charts printing small. I have installed the latest available version of Flash Player (10.1.102.64), and tried printing your print manager demo chart, as well as several others from your demos, and they all still print small. I am using IE7, though it does seem to be working perfectly in Firefox. The internal users at my company all have managed desktops, so upgrading it IE8 is not something I can do, as i have to keep the same version as the users. Thanks Martin

That's great. Many thanks.

Hi I'm not sure I've explained my question very well. I want to show a legend without a 'symbol' shown for each series, just the series name, but still keep the interactive element. In my example, my three series (FTSE 100, FTSE250 and FTSE350) want to show as just text, and when clicked, the interactive element will still switch them on/off without the need for me to set the series colour. I hope I have explained that better. Martin

Thanks. Will take a look and come back if I have any more questions. Martin

Yes, that's exactly what I was looking for - thanks. I have a line chart showing three series. The series names are FTSE100, FTSE250 and FTSE350. The series colours are blue, yellow and red respectively. I currently have it set up so that the legend label text is fed from the chart names, and by clicking on the label (which is a link button), it sets the visibility of the series to transparent, and sets the link button text to grey, to mimic being disabled. Clicking again does the opposite. You can see a before and after image below. What I'd like is to use an interactive legend, but instead of a series identifier and text, just use text. I hope that makes sense? If you need any further clarification, please let me know. Martin

I have noticed in the latest release of the fusion library, each legend item is now shown with the series type, i.e. bars/columns/lines in the series colour to identify it, and if you click any legend item, it hides the series from view without the need to re-draw the chart. As I understand, this used to be be something that had to be coded for using javascript in earlier releases, and so although it is a good addition, can it be switched off so that the user cannot hide series by simply clicking the legend item? Also, can you use different indicators for the legend items? I have a line chart where I want specific text in the series colour as the legend item. Thanks Martin