private void btnChart_Click(object sender, EventArgs e)
{
btnTable_Click(sender, e);
DataGrid1.Sort(DataGrid1.Columns[0], ListSortDirection.Ascending);
chart1.Series.Clear();
chart1.BringToFront();
int x, y;
string type;
if (chartType == "Bar")
{
if (displayMode == "Separate")
{
chart1.Series.Add("Maintenance");
chart1.Series.Add("Inventory");
chart1.Series.Add("Employee");
chart1.Series.Add("Bills");
chart1.Series.Add("Loans");
chart1.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Column;
chart1.Series[1].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Column;
chart1.Series[2].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Column;
chart1.Series[3].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Column;
chart1.Series[4].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Column;
chart1.Series[0].IsValueShownAsLabel = true;
chart1.Series[1].IsValueShownAsLabel = true;
chart1.Series[2].IsValueShownAsLabel = true;
chart1.Series[3].IsValueShownAsLabel = true;
chart1.Series[4].IsValueShownAsLabel = true;
foreach (DataGridViewRow DGVR in DataGrid1.Rows)
{
x = int.Parse(DGVR.Cells[0].Value.ToString());
y = int.Parse(DGVR.Cells[2].Value.ToString());
type = DGVR.Cells[1].Value.ToString();
chart1.Series[type].Points.AddXY(x, y);
}
}
else
{
chart1.Series.Add("Expenses");
chart1.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Column;
chart1.Series[0].IsValueShownAsLabel = true;
foreach (DataGridViewRow DGVR in DataGrid1.Rows)
{
x = int.Parse(DGVR.Cells[0].Value.ToString());
y = int.Parse(DGVR.Cells[1].Value.ToString());
chart1.Series["Expenses"].Points.AddXY(x, y);
}
}
}
else if (chartType == "Line")
{
if (displayMode == "Separate")
{
chart1.Series.Add("Maintenance");
chart1.Series.Add("Inventory");
chart1.Series.Add("Employee");
chart1.Series.Add("Bills");
chart1.Series.Add("Loans");
chart1.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Line;
chart1.Series[1].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Line;
chart1.Series[2].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Line;
chart1.Series[3].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Line;
chart1.Series[4].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Line;
chart1.Series[0].IsValueShownAsLabel = true;
chart1.Series[1].IsValueShownAsLabel = true;
chart1.Series[2].IsValueShownAsLabel = true;
chart1.Series[3].IsValueShownAsLabel = true;
chart1.Series[4].IsValueShownAsLabel = true;
foreach (DataGridViewRow DGVR in DataGrid1.Rows)
{
x = int.Parse(DGVR.Cells[0].Value.ToString());
y = int.Parse(DGVR.Cells[2].Value.ToString());
type = DGVR.Cells[1].Value.ToString();
chart1.Series[type].Points.AddXY(x, y);
}
}
else
{
chart1.Series.Add("Expenses");
chart1.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Line;
chart1.Series[0].IsValueShownAsLabel = true;
foreach (DataGridViewRow DGVR in DataGrid1.Rows)
{
x = int.Parse(DGVR.Cells[0].Value.ToString());
y = int.Parse(DGVR.Cells[1].Value.ToString());
chart1.Series["Expenses"].Points.AddXY(x, y);
}
}
}
else
{
if (displayMode == "Separate") // Cannot display data in a pie chart
{
}
else
{
chart1.Series.Add("Expenses");
chart1.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Pie;
chart1.Series[0].IsValueShownAsLabel = true;
foreach (DataGridViewRow DGVR in DataGrid1.Rows)
{
x = int.Parse(DGVR.Cells[0].Value.ToString());
y = int.Parse(DGVR.Cells[1].Value.ToString());
//type = DGVR.Cells[1].Value.ToString();
chart1.Series["Expenses"].Points.AddXY(x, y);
}
}
}
}
private void btnChart_Click(object sender, EventArgs e)
{
btnTable_Click(sender, e);
try {
DataGrid1.Sort(DataGrid1.Columns[0], ListSortDirection.Ascending);
}
catch (Exception exception)
{
// No Records in the DataGrid
}
chart1.Series.Clear();
chart1.BringToFront();
int x, y;
string type;
if (chartType == "Bar")
{
if (displayMode == "Separate")
{
}
else
{
chart1.Series.Add("Profit");
chart1.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Column;
chart1.Series[0].IsValueShownAsLabel = true;
foreach (DataGridViewRow DGVR in DataGrid1.Rows)
{
x = int.Parse(DGVR.Cells[0].Value.ToString());
y = int.Parse(DGVR.Cells[1].Value.ToString());
chart1.Series["Profit"].Points.AddXY(x, y);
}
}
}
else if (chartType == "Line")
{
if (displayMode == "Separate")
{
}
else
{
chart1.Series.Add("Profit");
chart1.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Line;
chart1.Series[0].IsValueShownAsLabel = true;
foreach (DataGridViewRow DGVR in DataGrid1.Rows)
{
x = int.Parse(DGVR.Cells[0].Value.ToString());
y = int.Parse(DGVR.Cells[1].Value.ToString());
chart1.Series["Profit"].Points.AddXY(x, y);
}
}
}
else
{
if (displayMode == "Separate") // Cannot display data in a pie chart
{
}
else
{
chart1.Series.Add("Profit");
chart1.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Pie;
chart1.Series[0].IsValueShownAsLabel = true;
foreach (DataGridViewRow DGVR in DataGrid1.Rows)
{
x = int.Parse(DGVR.Cells[0].Value.ToString());
y = int.Parse(DGVR.Cells[1].Value.ToString());
//type = DGVR.Cells[1].Value.ToString();
chart1.Series["Profit"].Points.AddXY(x, y);
}
}
}
}
