How to bind the CSV data in WPF Chart (SfChart)?
This article explains how to bind the CSV data to the WPF Chart with the following steps.
Step 1: Initialize a data model that represents a data point for the Chart.
[Model]
public class Model { public string Month { get; set; } public double Appointments { get; set; } public Model(string month, double appointments) { Month= month; Appointments = appointments; } }
Step 2: Store the list of the data model (numbers and text) in a CSV file. Each line of the file is a data model. Each model consists of two fields, separated by commas.
[CSV Data]
Month,Appointments Jan,360 Feb,490 Mar,250 Apr,670 May,575 Jun,430 Jul,680 Aug,345 Sep,563 Oct,420 Nov,634 Dec, 277
Step 3: Convert CSV data to List<Model>.
[ViewModel]
public class ViewModel { public List<Model> Data { get; set; } public ViewModel() { Data = new List<Model>(ReadCSV("..\\..\\ChartData")); } public IEnumerable<Model> ReadCSV(string fileName) { List<string> lines = File.ReadAllLines(System.IO.Path.ChangeExtension(fileName, ".csv")).ToList(); //First row containing column names. lines.RemoveAt(0); return lines.Select(line => { string[] data = line.Split(','); return new Model(Convert.ToString(data[0]), Convert.ToDouble(data[1])); }); } }
Step 4: Bind the converted List<Model> to the SfChart.
[XAML]
<chart:SfChart> ... <chart:ColumnSeries ItemsSource="{Binding Data}" XBindingPath="Month" YBindingPath="Appointments"/> </chart:SfChart>
Download the complete sample in GitHub
Output:
Refer to this Documentation, to acquire more knowledge on data binding in WPF Charts.
See Also,
How to bind the JSON data in WPF Chart?
How to bind the SQL Database to the WPF chart?
How to bind the data table in WPF Chart?
Conclusion
I hope you enjoyed learning about how to bind the CSV data in WPF Chart (SfChart).
You can refer to our WPF Charts’s feature tour page to know about its other groundbreaking feature representations. You can also explore our WPF Charts documentation to understand how to present and manipulate data.
For current customers, you can check out our WPF components from the License and Downloads page. If you are new to Syncfusion, you can try our 30-day free trial to check out our WPF Charts and other WPF components.
If you have any queries or require clarifications, please let us know in comments below. You can also contact us through our support forums, Direct-Trac, or feedback portal. We are always happy to assist you!