我正在尝试设置我的程序,以便用户可以显示一个堆积柱状图,显示每个部门中出现的拒绝类别数量(例如,在第1个部门中出现了5个,第2个部门中出现了3个等)。我在网上搜索并自己尝试过,但似乎无法使其正常工作。如果有人能够帮助,那就太棒了。
当用户按下按钮切换到堆积柱状图时,图表当前所做的事情: 代码:
当用户按下按钮切换到堆积柱状图时,图表当前所做的事情: 代码:
private void btnStacked_Click(object sender, EventArgs e)
{
charRejections.Series["RFR"].Enabled = false;
charRejections.Series["Department 1"].Points.Clear();
charRejections.Series["Department 1"].Enabled = true;
charRejections.Series["Department 2"].Points.Clear();
charRejections.Series["Department 2"].Enabled = true;
charRejections.Series["Department 3"].Points.Clear();
charRejections.Series["Department 3"].Enabled = true;
{
string connectiontring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\\Database1.mdb";
DataConnection = new OleDbConnection(connectiontring);
try
{
DataConnection.Open();
OleDbCommand command = new OleDbCommand();
command.Connection = DataConnection;
string query1 = "SELECT COUNT(reject_category) as reject, reject_category FROM tblReject_test GROUP BY reject_category";
command.CommandText = query1;
OleDbDataReader reader = command.ExecuteReader();
while (reader.Read())
{
charRejections.Series["Department 1"].Points.AddXY(reader["reject_category"].ToString(), reader["reject"].ToString());
charRejections.Series["Department 2"].Points.AddXY(reader["reject_category"].ToString(), reader["reject"].ToString());
charRejections.Series["Department 3"].Points.AddXY(reader["reject_category"].ToString(), reader["reject"].ToString());
}
DataConnection.Close();
}
catch (Exception ex)
{
MessageBox.Show("Error " + ex);
}
}
this.charRejections.Series["Department 1"].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.StackedColumn;
this.charRejections.Series["Department 2"].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.StackedColumn;
this.charRejections.Series["Department 3"].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.StackedColumn;
}