Visualizing trends without the distraction of data markers can make a chart clearer and more professional. In this article we show you how to create a ScatterConnectedByCurvesWithoutDataMarker chart – a smooth scatter line where the individual points are hidden – using Aspose.Cells for .NET. The solution is completely code‑driven, works with any .NET language, and does not require Excel to be installed.

This article covers the following topics:

C# Excel Library to Create ScatterConnectedByCurvesWithoutDataMarker Charts

Aspose.Cells for .NET is a feature‑rich library that enables developers to create, modify, and render Excel files without relying on Microsoft Office. It provides a clean, object‑oriented API for working with worksheets, cells, formulas, and every chart type supported by Excel – including the ScatterConnectedByCurvesWithoutDataMarker chart.

Key benefits of using Aspose.Cells for chart creation:

  • Complete API coverage – all native Excel chart types are available.
  • No COM interop – works on any platform that supports .NET.
  • High performance – optimized for large workbooks and data sets.
  • Multiple output formats – XLSX, XLS, CSV, PDF, PNG, etc.

Getting started is simple:

PM> Install-Package Aspose.Cells

Tip: The library can also be added via the .NET CLI (dotnet add package Aspose.Cells) or by downloading the binary from the Aspose.Cells releases page.

Create a ScatterConnectedByCurvesWithoutDataMarker Chart in Excel using C#

Below is a complete, self‑contained C# example that demonstrates how to:

  1. Create a new workbook.
  2. Fill a worksheet with sample X‑Y data.
  3. Add a ScatterConnectedByCurvesWithoutDataMarker chart.
  4. Hide the data markers and fine‑tune axis titles.
  5. Save the workbook to an XLSX file.

Note: The chart type is accessed through ChartType.ScatterConnectedByCurvesWithoutMarker – the enum name reflects the without‑marker variant of the scatter‑connected‑by‑curves chart.

Explanation of the Code

StepWhat Happens
1A fresh Workbook is created; the first Worksheet (Sheet1) is retrieved.
2Two columns are filled – X Value and Y Value – with a small data set that will produce a smooth curve.
3ChartType.ScatterConnectedByCurvesWithoutMarker tells Aspose.Cells to generate a scatter chart where points are automatically connected with a smooth spline and no markers are drawn.
4NSeries.Add binds the data range. The true flag indicates that the first column (A) provides the X values, the second column (B) provides the Y values.
5MarkerStyle = ChartMarkerType.None removes the data markers that would otherwise appear on each point.
6Axis titles and minimum values are set for better readability.
7The workbook is persisted as an .xlsx file.

You can run this program on any machine with .NET 6.0+ (or .NET Framework 4.6.1+) after installing the Aspose.Cells NuGet package. The generated file will contain a clean, smooth line chart without any distracting markers.

Get a Free License

Aspose.Cells is a commercial product, but you can obtain a temporary free license for evaluation purposes:

  • Visit the Aspose temporary license page.
  • Follow the instructions to download a license file (Aspose.Cells.lic).
  • Add the license to your code before creating the first Workbook:
var license = new Aspose.Cells.License();
license.SetLicense("Aspose.Cells.lic");

Using a license removes the evaluation watermark and lifts usage limitations.

Free Resources

Continue learning and expanding your Excel automation skills with these free resources:

Conclusion

In this article we demonstrated how to create a ScatterConnectedByCurvesWithoutDataMarker chart using Aspose.Cells for .NET. The library lets you generate smooth, marker‑less scatter curves entirely in code, giving you full control over appearance, data binding, and output format. Integrate this technique into reporting tools, dashboards, or any automated Excel workflow to produce clean, professional visualizations without the overhead of Excel interop.

If you have questions or need further assistance, feel free to post on the Aspose.Cells support forum.

See Also