Updated Solution
DataTable dtPieChartData = new DataTable();
dtPieChartData.Columns.Add("Category");
dtPieChartData.Columns.Add("Total");
foreach (DataGridViewRow row in billingGridView.Rows)
{
int indexCategoryColumn = 1;
int indexTotalColumn = 4;
dtPieChartData.Rows.Add(row.Cells[indexCategoryColumn].Value,row.Cells[indexTotalColumn].Value);
}
chart1.DataSource = dtPieChartData;
chart1.Series["Series1"].XValueMember = "Category";
chart1.Series["Series1"].YValueMembers = "Total";
this.chart1.Titles.Add("Category Title");
chart1.Series["Series1"].ChartType = SeriesChartType.Pie;
chart1.Series["Series1"].IsValueShownAsLabel = true;