ASP.Net Chart Control: Display LegendText of Column Chart using C#

mukesh1

SOLVED CLOSED ACTIVE ANSWERED
User: mukesh1
Posted: on Apr 10, 2018 12:09 AM
Forum: ASP.Net AJAX
Answer: 1
Views: 9814

In refernce of question https://www.aspforums.net/Threads/581681/ASPNet-Chart-Control-Display-Tooltip-on-Bars-of-Column-Chart/.

Now problem create that it not showing date of task,and all column attached ,in right side showing series1,series2 with color, want task title there in place of series how to do that.

           DataSet ds = sql.getds("select task.task_title,task_performance.totalpoints,convert(varchar(20),date,113) as date from task_performance join task on task.task_id=task_performance.task_id where user_id='" + Session["iduser"].ToString() + "' and  task_performance.date between '" + lbldate.Text + "' and '" + DateTime.Now.ToString("dd-MMMM-yyyy") + "' order by task_performance_id desc");
           int rowcount = ds.Tables[0].Rows.Count;
           if (rowcount == 0)
           {
               lblperformance.Visible = true;
               lblperformance.Text = "No Task Performance Found";
           }
           else
           {
               lbltitle.Text = "";
               for (int i = 0; i < rowcount; i++)
               {
                   string title = ds.Tables[0].Rows[i][0].ToString();
                   String totalpoint = (ds.Tables[0].Rows[i][1]).ToString();
 
                   if (totalpoint == "")
                   {
                       totalpoint = "0";
                   }
Series series = new Series();
//Chart1.Series["Tasks"].Points.AddXY("Task" + (i + 1) + "" + "(" + ds.Tables[0].Rows[i][2].ToString() + ")", totalpoint);
//Chart1.Series["Tasks"].ToolTip = title;
Chart1.Series.Add(series);
Chart1.Series[i].Points.AddXY("Task" + (i + 1) + "" + "(" + ds.Tables[0].Rows[i][1].ToString() + ")", totalpoint);
Chart1.Series[i].ToolTip = title + "," + totalpoint;
 
lbltitle.Text += (i + 1) + "." + title + "<br>";
Chart1.ChartAreas["ChartArea1"].AxisX.MajorGrid.LineWidth = 0;
// Chart1.ChartAreas["ChartArea1"].AxisY.MajorGrid.LineWidth = 0;
 
Chart1.ChartAreas["ChartArea1"].AxisY.MajorGrid.LineColor = Color.Gray;
Chart1.ChartAreas["ChartArea1"].AxisX.LineColor = Color.Gray;
Chart1.ChartAreas["ChartArea1"].AxisY.LineColor = Color.Gray;

                 <asp:Chart ID="Chart1" CssClass="chart-legend" runat="server" Width="932px">
                     <Series>
                         <asp:Series Name="Tasks" YValuesPerPoint="6" ChartType="Column"  CustomProperties="LabelStyle=Top" YValueType="Int32" IsValueShownAsLabel="true" >
                               <EmptyPointStyle IsValueShownAsLabel="false" IsVisibleInLegend="false" /></asp:Series>
                     </Series>
                     <ChartAreas>
                         <asp:ChartArea Name="ChartArea1" ></asp:ChartArea>
                     </ChartAreas>
                     <Legends>
                           <asp:Legend Name="Task point"  Alignment="Center" Docking="Right">
                           </asp:Legend>
                      </Legends>
                 </asp:Chart>

Total points of all columns not coming on top,only 1st column point coming on top.

and in series where i placed task name by add series.LegendText = title; in this each task color is previous color in original chart.

Means Task color and Chart column color not matching

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

dharmend...

0 5

Reply
ANSWER
User: dharmendr
Replied: on Apr 10, 2018 04:34 AM
Modified: on Apr 10, 2018 04:35 AM
Report

Hi mukesh1,

mukesh1 says:

Total points of all columns not coming on top,only 1st column point coming on top.

This is since you have assigned default series in html. That series total is displaying in the 1st column. And your IsValueShownAsLabel is set as false so. So the other value are not displaying on top. So to resolve the issue you need to clear the default series before adding the new series to the chart and set the IsValueShownAsLabel to true.

Check this example. Now please take its reference and correct your code.

protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        DataTable dt = new DataTable();
        dt.Columns.AddRange(new DataColumn[3] { 
            new DataColumn("task_title", typeof(string)), 
            new DataColumn("totalpoints", typeof(int)), 
            new DataColumn("date", typeof(DateTime)) });
        dt.Rows.Add("a", 30, "01/02/2017");
        dt.Rows.Add("e", 20, "02/02/2017");
        dt.Rows.Add("g", 33, "03/02/2017");
        DataSet ds = new DataSet();
        ds.Tables.Add(dt);
        int rowcount = ds.Tables[0].Rows.Count;
        if (rowcount == 0)
        {
            lblperformance.Visible = true;
            lblperformance.Text = "No Task Performance Found";
        }
        else
        {
            // Clear the default series.
            Chart1.Series.Clear();
            for (int i = 0; i < rowcount; i++)
            {
                string title = ds.Tables[0].Rows[i][0].ToString();
                String totalpoint = (ds.Tables[0].Rows[i][1]).ToString();

                if (totalpoint == "")
                {
                    totalpoint = "0";
                }

                Series series = new Series();
                // Display the value on top of each column.
                series.IsValueShownAsLabel = true;
                // Display the Legent.
                series.LegendText = title;
                Chart1.Series.Add(series);
                Chart1.Series[i].Points.AddXY("Task" + (i + 1) + "" + "(" + ds.Tables[0].Rows[i][1].ToString() + ")", totalpoint);
                Chart1.Series[i].ToolTip = title + "," + totalpoint;
                lbltitle.Text += (i + 1) + "." + title + "<br>";
                Chart1.ChartAreas["ChartArea1"].AxisX.MajorGrid.LineWidth = 0;
                Chart1.ChartAreas["ChartArea1"].AxisY.MajorGrid.LineColor = Color.Gray;
                Chart1.ChartAreas["ChartArea1"].AxisX.LineColor = Color.Gray;
                Chart1.ChartAreas["ChartArea1"].AxisY.LineColor = Color.Gray;
            }
        }
    }
}

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

ASP.Net Chart Control: Display LegendText of Column Chart using C#

Company

Explore

Follow us

Contact Us