Uchi Report post Posted December 28, 2012 Is there a way to display the total sum of the pie chart in fusion charts? [color=#00008B]public[/color] [color=#00008B]string[/color] [color=#2B91AF]CreateChart[/color]() { [color=#2B91AF]SqlConnection[/color] con = [color=#00008B]new[/color] [color=#2B91AF]SqlConnection[/color]([color=#2B91AF]ConfigurationManager[/color].[color=#2B91AF]ConnectionStrings[/color][[color=#800000]"MyConnectionString"[/color]].[color=#2B91AF]ConnectionString[/color]); [color=#00008B]string[/color] sqlStatement = [color=#800000]"SELECT Category, AvgNumbers FROM MyTable"[/color]; [color=#2B91AF]SqlCommand[/color] cmd = [color=#00008B]new[/color] [color=#2B91AF]SqlCommand[/color](sqlStatement, con); con.[color=#2B91AF]Open[/color](); [color=#2B91AF]SqlDataReader[/color] reader = cmd.[color=#2B91AF]ExecuteReader[/color](); [color=#00008B]string[/color] strXML; strXML = [color=#800000]"<graph caption='Average Days To Close' subcaption='I want to show here the Total Sum' labelDisplay='auto' useEllipsesWhenOverflow='1' decimalPrecision='0' showValues='1' enablesmartlabels='0' showlabels='0' legendAllowDrag='1' numberSuffix=' Days' showLegend='1' pieSliceDepth='45' formatNumberScale='0'>"[/color]; [color=#00008B]while[/color] (reader.[color=#2B91AF]Read[/color]()) { strXML += [color=#800000]"<set name='"[/color] + reader[[color=#800000]"Category"[/color]].[color=#2B91AF]ToString[/color]() + [color=#800000]"' value='"[/color] + reader[[color=#800000]"AvgNumbers"[/color]].[color=#2B91AF]ToString[/color]() + [color=#800000]"' />"[/color]; } strXML += [color=#800000]"</graph>"[/color]; [color=#00008B]return[/color] [color=#2B91AF]FusionCharts[/color].[color=#2B91AF]RenderChart[/color]([color=#800000]"/FusionCharts/Pie3D.swf"[/color], [color=#800000]"ChartID"[/color], strXML, [color=#800000]"FactorySum"[/color], [color=#800000]"450"[/color], [color=#800000]"450"[/color], [color=#00008B]false[/color], [color=#00008B]false[/color]); } Share this post Link to post Share on other sites
Guest Bindhu Report post Posted December 29, 2012 (edited) Hi, A warm welcome to the FusionCharts Forum Please refer to the below link : http://forum.fusioncharts.com/topic/13089-how-to-show-total-sum-values-on-pie-chart/page__gopid__51422#entry51422 Hope this helps. Edited December 29, 2012 by Bindhu Share this post Link to post Share on other sites