title: ASP.NET Pie chart only displaying YValueMembers
body: <p>I am trying to create a chart to display the percentage of checked and unchecked answer booklets.But the pie chart is only showing the unchecked value which is the YValueMember. How to resolve this?</p>
  
  <pre><code> protected void DropDown_Subjects_SelectedIndexChanged(object sender, EventArgs e)
  {
      Chart4.Visible = true;
      SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString);
      SqlCommand cmd = new SqlCommand("select checked_percent, unchecked_percent From(select COUNT(*) * 100.0 / (select count(*)from[newexam2017].[dbo].[newexam2017] where sub_code = '" + DropDown_Subjects.SelectedValue + "') as checked_percent from[newexam2017].[dbo].[newexam2017]  where CheckBy is not null and sub_code = '" + DropDown_Subjects.SelectedValue + "' )checked,(select COUNT(*) * 100.0 / (select count(*)from[newexam2017].[dbo].[newexam2017] where sub_code = '" + DropDown_Subjects.SelectedValue + "')as unchecked_percent from[newexam2017].[dbo].[newexam2017]  where CheckBy is  null and sub_code = '" + DropDown_Subjects.SelectedValue + "')unchecked", connection);
      connection.Open();
  
  
      SqlDataAdapter da = new SqlDataAdapter(cmd);
      DataSet ds = new DataSet();
      da.Fill(ds);
  
      DataTable ChartData = ds.Tables[0];
      Chart4.DataSource = ChartData;
  
      Chart4.Series[0].Points.DataBind(ChartData.DefaultView, "checked_percent", "unchecked_percent", "");
  
      for (int i = 0; i &lt; Chart4.Series[0].Points.Count; i++)
      Chart4.Series[0].Points[i].Label = string.Format("{0:0.00}%", ChartData.Rows[i]["checked_percent"], "{0:0.00}%", ChartData.Rows[i]["unchecked_percent"]);
  
  
      connection.Close();
     }
  </code></pre>
  
  <p>asp code:</p>
  
  <pre><code>        &lt;asp:Chart ID="Chart4" runat="server"  BackColor="DarkSlateBlue" BackGradientStyle="LeftRight"  
          BorderlineWidth="0" Height="440px" Palette="SeaGreen" PaletteCustomColors="24, 0, 0"  
          Width="560px" BorderlineColor="128, 128, 255" OnLoad="Chart4_Load"&gt;
  
               &lt;Titles&gt;
              &lt;asp:Title Name="DefaultTitle" Font="Trebuchet MS, 15pt, style=Bold"
                    Text = "Overall Scoring Progress" /&gt;
        &lt;/Titles&gt;
      &lt;%--  &lt;Legends&gt;
              &lt;asp:Legend Name="DefaultLegend" Enabled="True" Docking="Top" /&gt;
        &lt;/Legends&gt;--%&gt;
  
              &lt;Series&gt;
                  &lt;asp:Series Name="Series1"  IsValueShownAsLabel="true"  YValuesPerPoint="10"  ChartType="Pie"&gt;&lt;/asp:Series&gt;
              &lt;/Series&gt;
              &lt;ChartAreas&gt;
                  &lt;asp:ChartArea Name="ChartArea4" &gt;
  
  &lt;/asp:ChartArea&gt;
              &lt;/ChartAreas&gt;
          &lt;/asp:Chart&gt;
  </code></pre>
  
  <p>What I want:</p>
  
  <p><a href="https://i.stack.imgur.com/WI15a.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/WI15a.png" alt="chart1"></a></p>
  
  <p>What I get :</p>
  
  <p><a href="https://i.stack.imgur.com/H0dTB.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/H0dTB.png" alt="chart2"></a></p>