Category / Section
How do I create a Scatter Chart using Essential WinForms XlsIO?
4 mins read
In .NET Excel library Scatter chart with X and Y values can be created by providing separate range for series and the axis. Please refer to the below code snippet:
C#
// Create a scatter chart
IChartShape chart = sheet.Charts.Add();
IChartSerie serie = chart.Series.Add("Scatter Chart");
// Set the chart type
serie.SerieType = ExcelChartType.Scatter_Markers;
// This will create the serie
serie.Values = sheet.Range["C1:C5"];
// This will add the labels to the axis
serie.CategoryLabels = sheet.Range["B1:B5"];
VB
' Create a scatter chart
Dim chart As IChartShape = sheet.Charts.Add()
Dim serie As IChartSerie = chart.Series.Add("Scatter Chart")
' Set the chart type
serie.SerieType = ExcelChartType.Scatter_Markers
' This will create the serie
serie.Values = sheet.Range("C1:C5")
' This will add the labels to the axis
serie.CategoryLabels = sheet.Range("B1:B5")
Here is the sample for your reference:
Conclusion
I hope you enjoyed learning about how do I create a Scatter Chart using Essential WinForms XlsIO (Excel).
You can refer to our .NET Excel library page to know about its other groundbreaking feature representations and documentation, to understand how to create and manipulate data.
For current customers, you can check out our 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 other controls.
If you have any queries or require clarifications, please let us know in the comments section below. You can also contact us through our support forums, Direct-Trac, or feedback portal. We are always happy to assist you!
