Visualizing data points as a smooth line without markers is often required for clean trend analysis. Aspose.Cells for .NET makes it effortless to generate a ScatterConnectedByLinesWithoutDataMarker chart directly from code. In this guide you will learn how to create such a chart, customize its appearance, and export the workbook to XLSX, PDF, or image formats.
This article covers the following topics:
- Aspose.Cells .NET Library to Create ScatterConnectedByLinesWithoutDataMarker Charts
- Create ScatterConnectedByLinesWithoutDataMarker Chart in Excel using C#
- Advanced Customization Example
- Free License
- Free Resources
- Conclusion
- See Also
Aspose.Cells .NET Library to Create ScatterConnectedByLinesWithoutDataMarker Charts
Aspose.Cells for .NET is a comprehensive Excel manipulation library that enables developers to create, edit, and render Excel files without Microsoft Office installed. It supports a wide range of chart types, including the ScatterConnectedByLinesWithoutDataMarker chart, which displays a scatter plot linked by smooth lines while omitting the individual data markers.
Key benefits of using Aspose.Cells for chart generation:
- Full API coverage – Access every chart property programmatically.
- High fidelity rendering – Charts look identical to native Excel.
- Multiple export options – Save as XLSX, PDF, PNG, JPEG, etc.
- No COM interop – Works on any platform that supports .NET.
To start using Aspose.Cells, add the NuGet package to your project:
PM> Install-Package Aspose.Cells
Create ScatterConnectedByLinesWithoutDataMarker Chart in Excel using C#
Below is a straightforward example that creates a workbook, inserts sample data, adds a ScatterConnectedByLinesWithoutDataMarker chart, and saves the file.
Explanation of key steps
| Step | Description |
|---|---|
| 1 | Instantiates a Workbook and retrieves the first Worksheet. |
| 2 | Writes X‑Y pairs to cells A2:B6. |
| 3 | Adds a chart of type ScatterConnectedByLinesWithoutDataMarker. |
| 4 | Creates a series with Y values (B2:B6) and links X values via CategoryData. |
| 5 | (Optional) Sets axis titles and grid lines to improve readability. |
| 6 | Saves the workbook as an XLSX file. |
Running the code produces ScatterConnectedByLinesWithoutDataMarker.xlsx, which displays a smooth line connecting the data points without any markers.
Advanced Customization
In many scenarios you might need to style the line, add a secondary axis, or export the chart as an image. The following example demonstrates these tasks.
What this example adds
- Two series – one plotted on the primary Y‑axis and another on the secondary Y‑axis.
- Custom line styles – blue solid line for the primary series, red dashed line for the secondary.
- Export to image – uses
Chart.ToImage()to render the chart as a PNG file.
These techniques give you full control over the visual appearance of the ScatterConnectedByLinesWithoutDataMarker chart and allow you to reuse the chart outside of Excel.
Free License
Aspose offers a temporary free license that removes evaluation watermarks and enables full API access for a limited period. Get yours at the Aspose temporary license page.
// Apply a temporary license (optional for production builds)
var license = new Aspose.Cells.License();
license.SetLicense("Aspose.Cells.lic");
Free Resources
- Developer’s guide – https://docs.aspose.com/cells/net/
- Online demo & API tester – https://products.aspose.app/cells/family
- API reference – https://reference.aspose.com/cells/net/
- How‑to articles – https://blog.aspose.com/categories/aspose.cells-product-family/
Conclusion
Creating a ScatterConnectedByLinesWithoutDataMarker chart with Aspose.Cells for .NET is simple and fully customizable. The provided examples cover basic chart creation, dual‑axis handling, line styling, and exporting to image formats. By leveraging Aspose.Cells you can generate high‑quality Excel charts programmatically without requiring Microsoft Excel on the server.
For additional assistance, visit the Aspose support forum.