DataTable to chart

Question

I have a DataTable with 21 columns. I want to plot a graph of Cpk(column name)(X axis ) and Delta_sigama(column name)(y axis).

Vulpes · Answer

Just wondering what you've got the ChartType set to as I think the default is 'Column'. If you haven't got it already, try this line: chart1.Series["Series2"].ChartType = SeriesChartType.Point;

Vulpes · Answer

It looks perfect but, for some unknown reason, I still can't get it to display like that in my version :( As far as changing the background color of the chart is concerned if, in you look at the ChartAreas collection in the Properties Box, you can set the BackColor property of each ChartArea. There's also a secondary BackColor you can set for gradient or hatching purposes.

Farhan Shariff · Answer

I have a question. can I colour the my graph back ground with different colours

Farhan Shariff · Answer

yeah sure ...http://imgur.com/rV2cEfG

Vulpes · Answer

It had actually dawned on me when I tried to build this earlier that the columns were strings but, even when I changed them to doubles, I still couldn't get the X-axis to display anything other than the individual values. I still can't even with the revised code in your last post :( Could you perhaps attach an image of what the chart looks like now.

Farhan Shariff · Answer

The problem here was the column type was string I only had to change the type of the column to double.I have also deleted the infinity rows The issue is that when you are reading the data from the csv it is adding all the data as string and the chart is then reading the values as string thats why none of the Chart1.ChartAreas(0).AxisX.Maximum = 10 changes the axis. The column type have to be changed so private void button2_Click(object sender, EventArgs e) { DataTable dtCloned = csvData.Clone(); dtCloned.Columns["Delta_Sigma"].DataType = typeof(double); dtCloned.Columns["CpK_Refrence"].DataType = typeof(double); //dtCloned.Columns[3].DataType = typeof(double); foreach (DataRow row in csvData.Rows) { dtCloned.ImportRow(row); } chart1.DataSource = dtCloned; chart1.ChartAreas[0].AxisX.Minimum = 0; chart1.ChartAreas[0].AxisX.Maximum = 10; chart1.ChartAreas[0].AxisX.Minimum = -5; chart1.ChartAreas[0].AxisX.Maximum = 5; chart1.Series["Series2"].YValueMembers = "Delta_Sigma"; chart1.Series["Series2"].XValueMember = "CpK_Refrence"; chart1.DataBind(); }

Farhan Shariff · Answer

It is always good to delete the unwanted data .I will work on deleting the rows.

Vulpes · Answer

Yes, I can see why they would cause a problem and may be force the chart to a 'column' basis. Presumably, all the infinite values are gathered together on the x-axis. What you could try is to create an additional column in the datatable and replace the infinite values with some reasonable finite maximum (or minimum if they're negative infinity) or, otherwise, just copy the values across. You could then bind to the additional column. Alternatively, you could create a DefaultView and then filter out those rows which have infinite values in them.

Farhan Shariff · Answer

there are a few values in the column that are infinity I guess they are causing the trouble

Vulpes · Answer

It depends on how you're doing the data-binding. If you use Chart.DataSource then you can use a DataTable. However, if you're using DataPointCollection.DataBindXY, then you have to use a DataView instead because the data-source needs to implement IEnumerable which DataTable doesn't. I can't tell from the code what the ChartType is set to, so it must be using the setting in the Properties box.

Farhan Shariff · Answer

using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Windows.Forms; using System.Windows.Forms.DataVisualization.Charting; using Microsoft.VisualBasic.FileIO; namespace WindowsFormsApplication4 { public partial class Form1 : Form { private DataTable csvData; public Form1() { InitializeComponent(); private void button1_Click(object sender, EventArgs e) { OpenFileDialog openFileDialog = new OpenFileDialog(); // To list only csv files, we need to add this filter openFileDialog.Filter = "|*.csv"; DialogResult result = openFileDialog.ShowDialog(); if (result == DialogResult.OK) { tbCSVPath.Text = openFileDialog.FileName; } csvData = GetDataTableFromCSVFile(tbCSVPath.Text); } private static DataTable GetDataTableFromCSVFile(string csvfilePath) { DataTable csvData = new DataTable(); using (TextFieldParser csvReader = new TextFieldParser(csvfilePath)) { csvReader.SetDelimiters(new string[] { "," }); csvReader.HasFieldsEnclosedInQuotes = true; //Read columns from CSV file, remove this line if columns not exits string[] colFields = csvReader.ReadFields(); foreach (string column in colFields) { DataColumn datecolumn = new DataColumn(column); datecolumn.AllowDBNull = true; csvData.Columns.Add(datecolumn); } while (!csvReader.EndOfData) { string[] fieldData = csvReader.ReadFields(); //Making empty value as null for (int i = 0; i { if (fieldData[i] == "") { fieldData[i] = null; } } csvData.Rows.Add(fieldData); } } return csvData; } private void button2_Click(object sender, EventArgs e) { chart1.ChartAreas[0].AxisY.Maximum = 10; chart1.ChartAreas[0].AxisY.Minimum = 0; chart1.ChartAreas[0].AxisX.Maximum = 10; chart1.ChartAreas[0].AxisX.Minimum = 0; chart1.Series["Series2"].Points.DataBindXY(csvData.DefaultView, "CpK_Refrence", csvData.DefaultView, "Delta_Sigma"); } } }

Farhan Shariff · Answer

I have imported csv file to datatable can I use this as datasource to chart

Abhinav Abhishek · Answer

http://www.c-sharpcorner.com/UploadFile/e49581/graphical-report-in-windows-application-using-chart-control/

Farhan Shariff · Answer

nope it is the same.Can I use DataTable as DataSource to chart I want X axis as 0 1 2 3 4.. X axis scale is values in Cpk column

Vulpes · Answer

I'd see what you get if you replace the above code with this single line: chart1.Series["Series2"].Points.DataBindXY(csvData.DefaultView, "CpK", csvData.DefaultView, "Delta_Sigma");

Farhan Shariff · Answer

I used this but the X axis scale is being taken as values present in cpk column.I want x axis scale as 1 2 3 4 5 6 7 ..... chart1.DataSource = csvData; chart1.Series["Series2"].YValueMembers = "Delta_Sigma"; chart1.Series["Series2"].XValueMember = "CpK"; chart1.DataBind();

Abhay Shanker · Answer

Check the link can be helpful http://blogs.msdn.com/b/alexgor/archive/2009/02/21/data-binding-ms-chart-control.aspx http://www.etechpulse.com/2013/04/how-to-create-chart-using-data-table.html