Visualizing data points that are connected by smooth curves while still showing individual markers can greatly improve the readability of analytical reports. In this guide you will learn how to create a ScatterConnectedByCurvesWithDataMarker chart in Excel using C# with Aspose.Cells for .NET. The example covers data population, chart creation, series configuration, data‑marker customization, and workbook saving.

This article covers the following topics:

C# Excel Library to Create ScatterConnectedByCurvesWithDataMarker Chart

Aspose.Cells for .NET is a robust Excel manipulation library that empowers developers to create, modify, and style Excel files programmatically without Microsoft Office. It offers a rich Chart API that includes the ScatterConnectedByCurvesWithDataMarker chart type, enabling smooth curve connections with visible data markers.

Key advantages of Aspose.Cells for .NET:

  • Comprehensive API – Access every Excel feature from worksheets to advanced charts.
  • High Performance – Process large workbooks efficiently.
  • Zero Dependency on Office – No need for Excel installation on the server.
  • Multi‑Format Support – Read/write XLSX, XLS, CSV, ODS, PDF, and more.

Getting Started

  1. Download the latest release from the Aspose.Cells releases page.

  2. Install via NuGet:

    PM> Install-Package Aspose.Cells

  3. Add a reference to Aspose.Cells in your C# project.

Create a ScatterConnectedByCurvesWithDataMarker Chart in Excel using C#

The following example creates a workbook, inserts sample data, adds a ScatterConnectedByCurvesWithDataMarker chart, and saves the file as ScatterChart_Output.xlsx.

What the Code Does

StepDescription
1Instantiates a new Workbook and grabs the first Worksheet.
2Writes a header row and a set of X‑Y points into columns A and B.
3Inserts a chart of type ScatterConnectedByCurvesWithDataMarker at a specified location on the sheet.
4Adds a single data series. NSeries.Add sets the X range; YValues assigns the Y range.
5(Optional) Sets titles for the category (X) and value (Y) axes.
6Saves the workbook to disk.

Run the program; the generated ScatterChart_Output.xlsx will contain a smooth‑curve scatter chart where each point is highlighted by a data marker.

Customize Data Markers for the Scatter Chart

Data markers can be styled to improve visual impact. The example below demonstrates how to change marker shape, size, color, and border for the series created above.

Marker Customization Highlights

PropertyEffect
MarkerStyleChanges the shape (e.g., Diamond, Circle, Square).
MarkerSizeControls the size in points.
Area.ForeColor + Area.FormattingSets the fill color of the marker.
Border propertiesDefines outline visibility, color, weight, and line style.

By tweaking these properties you can match corporate branding, emphasize key data points, or simply improve chart aesthetics.

Get a Free License

Explore Aspose products risk‑free by requesting a temporary license. Visit the Aspose temporary license page to obtain a free key that unlocks the full functionality of Aspose.Cells for .NET.

Free Resources

Enhance your Excel automation skills with the following free resources:

Conclusion

In this article we demonstrated how to create a ScatterConnectedByCurvesWithDataMarker chart using C# and Aspose.Cells for .NET. The guide covered:

  1. Setting up a workbook and populating X‑Y data.
  2. Adding the specialized scatter chart type.
  3. Configuring series and axis titles.
  4. Customizing data markers for a polished visual output.

Aspose.Cells makes chart creation straightforward, allowing you to generate complex, publication‑ready visuals entirely programmatically.

If you have any questions, need further assistance, or wish to share your feedback, please visit our free support forum.

See Also