|
Scatter chart with X and Y values can be created by providing separate range for serie 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:
|
2X faster development
The ultimate WinForms UI toolkit to boost your development speed.
This page will automatically be redirected to the sign-in page in 10 seconds.
You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.
