How to create multiple column stacked barchart in c# asp.ne

Below code i using to create Stacked chart ,every month i display schduled ,release.Hold status ,Now i want display schduled column seperatly and need display other column release and Hold one column

in one column

below code using

Chart2.DataSource = ds;

           foreach (DataRow row in dt.Rows)

{

               int total = 0;

               //int sch = Convert.ToInt16(ds.Tables[0].Rows[i]["SCHCNT"].ToString());

               total += Convert.ToInt16(row["Hold"]);

               total += Convert.ToInt16(row["SCHCNT"]);

               total += Convert.ToInt16(row["Released"]);

               total += Convert.ToInt16(row["Addl"]);

               total += Convert.ToInt16(row["Notreleased"]);

               row["Total"] = total;

}

           // Set series members names for the X and Y values

           Chart2.Series["Series1"]["PixelPointWidth"] = "30";

           Chart2.Series["Series2"]["PixelPointWidth"] = "30";

           Chart2.Series["Series3"]["PixelPointWidth"] = "30";

           Chart2.Series["Series4"]["PixelPointWidth"] = "30";

           Chart2.Series["Series5"]["PixelPointWidth"] = "30";

           Chart2.Series["Series1"].XValueMember = "PERD";

           Chart2.Series["Series1"].YValueMembers = "SCHCNT";

           Chart2.Series["Series2"].XValueMember = "PERD";

           Chart2.Series["Series2"].YValueMembers = "Notreleased";

           Chart2.Series["Series3"].XValueMember = "PERD";

           Chart2.Series["Series3"].YValueMembers = "Released";

           Chart2.Series["Series4"].XValueMember = "PERD";

           Chart2.Series["Series4"].YValueMembers = "Hold";

           Chart2.Series["Series5"].XValueMember = "PERD";

           Chart2.Series["Series5"].YValueMembers = "Addl";

           Chart2.Series["Series6"].XValueMember = "PERD";

           Chart2.Series["Series6"].YValueMembers = "Total";

           Chart2.DataBind();

           foreach (System.Web.UI.DataVisualization.Charting.Series series in Chart2.Series)

{

               foreach (System.Web.UI.DataVisualization.Charting.DataPoint point in series.Points)

{

                   if (point.YValues.Length > 0 && (double)point.YValues.GetValue(0) == 0)

{

                       point.LegendText = point.AxisLabel;//In case you have legend

}

                   else

{

                       point.IsValueShownAsLabel = true;

                       if (series.ToString().Trim() == "Series-Series1")

{

                           point.LabelUrl = "DrawingStatus.aspx?mon=#VALX&flag=SCH&cprj=" + Request.QueryString["cprj"];

}

                       if (series.ToString().Trim() == "Series-Series2")

{

                           point.LabelUrl = "DrawingStatus.aspx?mon=#VALX&flag=NOT&cprj=" + Request.QueryString["cprj"];

}

                       if (series.ToString().Trim() == "Series-Series3")

{

                           point.LabelUrl = "DrawingStatus.aspx?mon=#VALX&flag=REL&cprj=" + Request.QueryString["cprj"];

}

                       if (series.ToString().Trim() == "Series-Series4")

{

                           point.LabelUrl = "DrawingStatus.aspx?mon=#VALX&flag=HOL&cprj=" + Request.QueryString["cprj"];

}

                       if (series.ToString().Trim() == "Series-Series5")

{

                           point.LabelUrl = "DrawingStatus.aspx?mon=#VALX&flag=Addl&cprj=" + Request.QueryString["cprj"];

}

}

}

               con.Close();

               con.Dispose();

}

}

       catch (Exception ex)

{

           if (con.State != ConnectionState.Closed)

{

               con.Close();

               con.Dispose();

               // con = null;

}

           Response.Write(ex.Message);

}

       finally

{

           con.Close();

           con.Dispose();

           con = null;

}

source code

<asp:Chart ID="Chart2" runat="server" Height="500px" Palette="None" Width="1000px"

                                    SuppressExceptions="True"  BackColor="146, 196, 59">

                                    <Series>

                                        <asp:Series Name="Series1" ChartArea="ChartArea1" XValueType="String" BorderWidth="2"

                                            Color="LightBlue" IsXValueIndexed="True" Legend="Legend1" LabelToolTip="#VALX : #VALY"

                                            LabelForeColor="Black" LegendText="Scheduled" LabelBackColor="#CE90D4" Font="Calibri, 8pt, style=Bold"

                                            MarkerSize="10" MarkerStyle="Star4" YValuesPerPoint="4"

                                            ChartType="StackedColumn">

                                            <Points>

                                                <asp:DataPoint MarkerStyle="None" YValues="0,0,0,0" BackGradientStyle="None" BorderWidth="4"

                                                    CustomProperties="LabelStyle=Top" IsEmpty="True" XValue="2" />

                                            Points>

                                            <EmptyPointStyle IsValueShownAsLabel="true" />

                                            <SmartLabelStyle CalloutLineAnchorCapStyle="Diamond" />

                                        asp:Series>

                                        <asp:Series ChartArea="ChartArea1" Name="Series3" XValueType="String" BorderWidth="2"

                                            Color="Green" IsXValueIndexed="True" Legend="Legend1" LabelToolTip="#VALX : #VALY"

                                            LabelForeColor="Black" LegendText="Released" LabelBackColor="Cyan" Font="Calibri, 8pt, style=Bold"

                                            MarkerSize="10" MarkerStyle="Star4" YValuesPerPoint="4"

                                            ChartType="StackedColumn">

                                            <Points>

                                                <asp:DataPoint MarkerStyle="None" YValues="0,0,0,0" BackGradientStyle="None" BorderWidth="4"

                                                    CustomProperties="LabelStyle=Top" IsEmpty="True" XValue="2" />

                                            Points>

                                            <EmptyPointStyle />

                                            <SmartLabelStyle CalloutLineAnchorCapStyle="Diamond" />

                                        asp:Series>

                                        <asp:Series ChartArea="ChartArea1" Name="Series2" XValueType="String" BorderWidth="2"

                                            Color="Red" IsXValueIndexed="True" Legend="Legend1" LabelToolTip="#VALX : #VALY"

                                            LabelForeColor="Black" LegendText="Not Released" LabelBackColor="Gray" Font="Calibri, 8pt, style=Bold"

                                            MarkerSize="10" MarkerStyle="Star4" YValuesPerPoint="4"

                                            ChartType="StackedColumn">

                                            <Points>

                                                <asp:DataPoint MarkerStyle="None" YValues="0,0,0,0" BackGradientStyle="None" BorderWidth="4"

                                                    CustomProperties="LabelStyle=Top" IsEmpty="True" XValue="2" />

                                            Points>

                                            <EmptyPointStyle />

                                            <SmartLabelStyle CalloutLineAnchorCapStyle="Diamond" />

                                        asp:Series>

                                        <asp:Series Name="Series4" ChartArea="ChartArea1" XValueType="String" BorderWidth="2"

                                            Color="Yellow" IsXValueIndexed="True" Legend="Legend1" LabelToolTip="#VALX : #VALY"

                                            LabelForeColor="Black" LegendText="On-Hold" LabelBackColor="Lavender" Font="Calibri, 8pt, style=Bold"

                                            MarkerSize="10" MarkerStyle="Star4" YValuesPerPoint="4"

                                            ChartType="StackedColumn">

                                            <Points>

                                                <asp:DataPoint MarkerStyle="None" YValues="0,0,0,0" BackGradientStyle="None" BorderWidth="4"

                                                    CustomProperties="LabelStyle=Top" IsEmpty="True" XValue="2" />

                                            Points>

                                            <EmptyPointStyle IsValueShownAsLabel="true" />

                                            <SmartLabelStyle CalloutLineAnchorCapStyle="Diamond" />

                                        asp:Series>

                                        <asp:Series Name="Series5" ChartArea="ChartArea1" XValueType="String" BorderWidth="2"

                                            Color="Blue" IsXValueIndexed="True" Legend="Legend1" LabelToolTip="#VALX : #VALY"

                                            LabelForeColor="Black" LegendText="Additional" LabelBackColor="Gray" Font="Calibri, 8pt, style=Bold"

                                            MarkerSize="10" MarkerStyle="Star4" YValuesPerPoint="4"

                                            ChartType="StackedColumn">

                                            <Points>

                                                <asp:DataPoint MarkerStyle="None" YValues="0,0,0,0" BackGradientStyle="None" BorderWidth="4"

                                                    CustomProperties="LabelStyle=Top" IsEmpty="True" XValue="2" />

                                            Points>

                                            <EmptyPointStyle IsValueShownAsLabel="true" />

                                            <SmartLabelStyle CalloutLineAnchorCapStyle="Diamond" />

                                        asp:Series>

                                          <asp:Series Name="Series6" ChartType="Point" ChartArea="ChartArea1" XValueType="String" BorderWidth="2"

                                            Color="Black" IsXValueIndexed="True" Legend="Legend1" LabelToolTip="#VALX : #VALY"

                                            LabelForeColor="DarkBlue" LegendText="Total" LabelBackColor="#CE90D4" Font="Calibri, 8pt, style=Bold"

                                            MarkerSize="10" MarkerStyle="Star4" YValuesPerPoint="4" >

                                            <Points>

                                                <asp:DataPoint MarkerStyle="None" YValues="0,0,0,0" BackGradientStyle="None" BorderWidth="4"

                                                    CustomProperties="LabelStyle=Top" IsEmpty="True" XValue="2" />

                                            Points>

                                            <EmptyPointStyle IsValueShownAsLabel="true" />

                                            <SmartLabelStyle CalloutLineAnchorCapStyle="Diamond" />

                                        asp:Series>

                                    Series>

                                    <ChartAreas>

                                        <asp:ChartArea Name="ChartArea1" AlignmentOrientation="All" BackColor="255, 255, 128"

                                            BackGradientStyle="DiagonalRight">

                                            <AxisY ArrowStyle="None" InterlacedColor="White" IntervalType="Number" TextOrientation="Rotated270"

                                                Title=" No. of Drawings" MaximumAutoSize="100" TitleFont="Calibri, 14.25pt, style=Bold"

                                                TitleForeColor="Black">

                                                <MajorGrid IntervalOffset="Auto" LineDashStyle="Solid" IntervalOffsetType="Number"

                                                    IntervalType="Number" Enabled="False" />

                                                <MajorTickMark Interval="50" />

                                                <StripLines>

                                                    <asp:StripLine BackColor="192, 255, 255" />

                                                StripLines>

                                                <LabelStyle Font="Calibri, 10pt, style=Bold" ForeColor="Black" />

                                                <ScaleBreakStyle Spacing="2.5" StartFromZero="No" />

                                            AxisY>

                                            <AxisX Title="Month" Crossing="Min" Enabled="True" Interval="1" IntervalAutoMode="VariableCount"

                                                IsLabelAutoFit="False" IsMarksNextToAxis="False" MaximumAutoSize="100" TitleFont="Calibri, 14.25pt, style=Bold"

                                                TitleForeColor="Black">

                                                <StripLines>

                                                    <asp:StripLine />

                                                StripLines>

                                                <LabelStyle Font="Calibri, 10pt, style=Bold" ForeColor="Black" Interval="1" IntervalOffset="Auto"

                                                    IntervalOffsetType="Auto" IntervalType="Number" />

                                                <ScaleBreakStyle BreakLineStyle="Wave" Enabled="True" Spacing="2.5" StartFromZero="Yes" />

                                                <ScaleView Position="1" Size="12" />

                                                <MajorGrid LineWidth="0" />

                                            AxisX>

                                        asp:ChartArea>

                                    ChartAreas>

                                    <Legends>

                                        <asp:Legend Name="Legend1" DockedToChartArea="NotSet" Docking="Bottom" Alignment="Far">

                                        asp:Legend>

                                    Legends>

                                    <Titles>

                                        <%-- <asp:Title Text="Click on values for details" Docking="Top" ForeColor="Red" Alignment="TopRight">asp:Title>--%>

                                    Titles>

                                asp:Chart>

1 Reply
Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Sign inCreate an account

Bhuvanesh Mohankumar10y agoPosted May 13, 2016, 2:38 AM Can you use any third part char controls, is that allowed or you need any restrictions. You have many Jquery chart application where you need to simply add that char.js files and assign value to that chart from Jquery and that will give you a glossy char on you UI. Sample: http://www.highcharts.com/ Refer this site, you can view the chart and you can just copy and paste the code of chart, after that just change the hardcoded chart values with your own data values. Mark as answer, if helpful. 0