how to siplay total value in stacked bar chart top in asp.net code project

venkatsa...

SOLVED CLOSED ACTIVE ANSWERED
User: venkatsan
Posted: on Mar 18, 2016 05:49 AM
Forum: HTML and CSS
Answer: 1
Views: 9026
Sample Code: Download

Below Code I using to display Stacked Barchart in asp.net ,But can did't display Total value of the columns Top of the columns ,

below link my refernce link ,PLease provide your solution

http://www.fourthbottle.com/2014/12/how-to-create-stacked-bar-chart-using.html

Thanks & Regrads

Venkat

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="MobileSales.aspx.cs" Inherits="ASPChartApp.MobileSales" %>

<%@ Register Assembly="System.Web.DataVisualization, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" Namespace="System.Web.UI.DataVisualization.Charting" TagPrefix="asp" %>
<html><body>
<form id="form1" runat="server">
<div>

<asp:Chart ID="MobileSalesChart" runat="server" Width="500px" Height="350px" ToolTip="Mobile Sales" BorderlineColor="Gray">

<Series>
<asp:Series Name="Apple" IsValueShownAsLabel="true" ChartType="StackedColumn" LegendText="Apple"></asp:Series>
<asp:Series Name="Nokia" IsValueShownAsLabel="true" ChartType="StackedColumn"></asp:Series>
<asp:Series Name="Samsung" IsValueShownAsLabel="true" ChartType="StackedColumn"></asp:Series>
<asp:Series Name="Sony" IsValueShownAsLabel="true" ChartType="StackedColumn"></asp:Series>
<asp:Series Name="Motorola" IsValueShownAsLabel="true" ChartType="StackedColumn"></asp:Series>
<%--Name- you can change the product name here such as type, type2--%>
<%--IsValueShownAsLabel- you can enable the count to show on each columns and each series--%>
<%--Each series represents each colour in a column--%>
</Series>
<Legends>
<asp:Legend Name="MobileBrands" Docking="Bottom" Title="Mobile Sales (in 1000's)" TableStyle="Wide" BorderDashStyle="Solid" BorderColor="#e8eaf1" TitleSeparator="Line" TitleFont="TimesNewRoman" TitleSeparatorColor="#e8eaf1">
</asp:Legend>
<%--Legends denotes the representing color for each brands--%>
<%--It will automatically takes the names from the series names and it's associated colors or you can give legend text in series--%>
</Legends>
<ChartAreas>
<asp:ChartArea Name="ChartArea1">
<AxisX>
<MajorGrid Enabled="false" />
</AxisX>
</asp:ChartArea>
</ChartAreas>
</asp:Chart>
</div>
</form>
</body>
</html>

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Web.UI.DataVisualization.Charting;

namespace ASPChartApp
{
    public partial class MobileSales : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
          DataSet ds = new DataSet("MobileSales");
          SqlConnection con = new SqlConnection(@"connection String");
          SqlDataAdapter dataAdapter = new SqlDataAdapter("Select * from MobileSales", con);
          con.Open();
          dataAdapter.Fill(ds);
          con.Close();
          if (ds.Tables[0].Rows.Count > 0)
          {
             for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
             {
                    MobileSalesChart.Series["Apple"].Points.Add(new DataPoint(i, ds.Tables[0].Rows[i]["Apple"].ToString().Trim()));
                    MobileSalesChart.Series["Nokia"].Points.Add(new DataPoint(i, ds.Tables[0].Rows[i]["Nokia"].ToString().Trim()));
                    MobileSalesChart.Series["Samsung"].Points.Add(new DataPoint(i, ds.Tables[0].Rows[i]["Samsung"].ToString().Trim()));
                    MobileSalesChart.Series["Sony"].Points.Add(new DataPoint(i, ds.Tables[0].Rows[i]["Sony"].ToString().Trim()));
                    MobileSalesChart.Series["Motorola"].Points.Add(new DataPoint(i, ds.Tables[0].Rows[i]["Motorola"].ToString().Trim()));
                    MobileSalesChart.Series[0].Points[i].AxisLabel = ds.Tables[0].Rows[i]["Year"].ToString().Trim();
              }
           }
       }
   }

}

Download FREE API for Word, Excel and PDF in ASP.Net

Shashika...

0 1

Reply
ANSWER
User: Shashikant
Replied: on Mar 18, 2016 05:53 AM
Report

Here I have created sample that wil help you out.

HTML

<div>
    <div>
        <asp:Chart ID="MobileSalesChart" runat="server" Width="500px" Height="500px" ToolTip="Mobile Sales"
            BorderlineColor="Gray">
            <Series>
                <asp:Series Name="Apple" IsValueShownAsLabel="true" ChartType="StackedColumn" LegendText="Apple">
                </asp:Series>
                <asp:Series Name="Nokia" IsValueShownAsLabel="true" ChartType="StackedColumn">
                </asp:Series>
                <asp:Series Name="Samsung" IsValueShownAsLabel="true" ChartType="StackedColumn">
                </asp:Series>
                <asp:Series Name="Sony" IsValueShownAsLabel="true" ChartType="StackedColumn">
                </asp:Series>
                <asp:Series Name="Motorola" IsValueShownAsLabel="true" ChartType="StackedColumn">
                </asp:Series>
                <asp:Series Name="Total" IsValueShownAsLabel="true" ChartType="Point" LegendText="Total">
                </asp:Series>
            </Series>
            <Legends>
                <asp:Legend Name="MobileBrands" Docking="Bottom" Title="Mobile Sales (in 1000's)"
                    TableStyle="Wide" BorderDashStyle="Solid" BorderColor="#e8eaf1" TitleSeparator="Line"
                    TitleFont="TimesNewRoman" TitleSeparatorColor="#e8eaf1">
                </asp:Legend>
            </Legends>
            <ChartAreas>
                <asp:ChartArea Name="ChartArea1">
                    <AxisX>
                        <MajorGrid Enabled="false" />
                    </AxisX>
                </asp:ChartArea>
            </ChartAreas>
        </asp:Chart>
    </div>
</div>

protected void Page_Load(object sender, EventArgs e)
{

    DataTable dt = new DataTable();
    dt.Columns.AddRange(new DataColumn[] { 
        new DataColumn("Apple"),
        new DataColumn("Nokia"),
        new DataColumn("Samsung"),
        new DataColumn("Sony"),
        new DataColumn("Motorola"),
        new DataColumn("Year")
    });
    dt.Rows.Add(1000, 200, 500, 400, 400, 2014);
    dt.Rows.Add(2000, 500, 500, 600, 400, 2015);
    dt.Columns.Add("Total");
    foreach (DataRow row in dt.Rows)
    {
        int total = 0;
        total += Convert.ToInt32(row["Apple"]);
        total += Convert.ToInt32(row["Nokia"]);
        total += Convert.ToInt32(row["Samsung"]);
        total += Convert.ToInt32(row["Sony"]);
        total += Convert.ToInt32(row["Motorola"]);
        row["Total"] = total;
    }

    if (dt.Rows.Count > 0)
    {
        for (int i = 0; i < dt.Rows.Count; i++)
        {
            MobileSalesChart.Series["Total"].Points.Add(new DataPoint(i, dt.Rows[i]["Total"].ToString().Trim()));
            MobileSalesChart.Series["Apple"].Points.Add(new DataPoint(i, dt.Rows[i]["Apple"].ToString().Trim()));
            MobileSalesChart.Series["Nokia"].Points.Add(new DataPoint(i, dt.Rows[i]["Nokia"].ToString().Trim()));
            MobileSalesChart.Series["Samsung"].Points.Add(new DataPoint(i, dt.Rows[i]["Samsung"].ToString().Trim()));
            MobileSalesChart.Series["Sony"].Points.Add(new DataPoint(i, dt.Rows[i]["Sony"].ToString().Trim()));
            MobileSalesChart.Series["Motorola"].Points.Add(new DataPoint(i, dt.Rows[i]["Motorola"].ToString().Trim()));
            MobileSalesChart.Series[0].Points[i].AxisLabel = dt.Rows[i]["Year"].ToString().Trim();
        }
    }
}

Screenshot

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

how to siplay total value in stacked bar chart top in asp.net code project

Company

Explore

Follow us

Contact Us