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

Question

Hi

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>