In asp.net chart All columns bottom text not showing
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
{
Chart1.Series.Clear();
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();
series.IsValueShownAsLabel = true;
series.LegendText = title + " (" + ds.Tables[0].Rows[i][2].ToString()+")";
Chart1.Series.Add(series);
Chart1.Series[i].Points.AddXY( "Task", totalpoint);
Chart1.Series[i].ToolTip = title + ", Date :" + ds.Tables[0].Rows[i][2].ToString();
//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>