Uchi

Display Total Sum Of A Pie Chart

Recommended Posts

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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now