Visualizing proportional data with markers can make trends stand out while preserving the relative contribution of each series. In this article you will learn how to create a Line100PercentStackedWithDataMarkers chart in an Excel workbook using C# and Aspose.Cells for .NET. The guide covers data preparation, chart creation, series configuration, and marker customization—all with ready‑to‑run code.
This article covers the following topics:
- C# Excel Library to Create Line100PercentStackedWithDataMarkers Chart
- Create a Line100PercentStackedWithDataMarkers Chart in Excel using C#
- Free Resources
- Conclusion
- See Also
C# Excel Library to Create Line100PercentStackedWithDataMarkers Chart
Aspose.Cells for .NET is a comprehensive Excel manipulation library that lets developers create, edit, and convert Excel files without Microsoft Office. It offers a rich set of chart types—including the Line100PercentStackedWithDataMarkers chart—plus full control over series, markers, axes, and formatting.
Key benefits of using Aspose.Cells for charting:
- Zero‑dependency – Works on any .NET platform, no Excel installation required.
- Full API coverage – Access to every chart property, style, and data point.
- High performance – Efficient handling of large workbooks and data sets.
- Multiple format support – Save to XLSX, XLS, CSV, PDF, PNG, and more.
Get started quickly:
Download the latest release from the Aspose.Cells .NET releases page.
Install via NuGet:
PM> Install-Package Aspose.Cells
Create a Line100PercentStackedWithDataMarkers Chart in Excel using C#
Overview
The following example demonstrates how to:
- Create a new workbook and worksheet.
- Populate the worksheet with sample data.
- Insert a Line100PercentStackedWithDataMarkers chart.
- Configure each series to display data markers.
- Apply basic formatting (title, axes, marker size/color).
- Save the workbook to an XLSX file.
Explanation of Key Steps
| Step | What it does |
|---|---|
| 2 | Populates a simple data table (Region vs. quarterly sales). |
| 3 | Adds a chart of type Line100PercentStackedWithDataMarkers. This type stacks each series to 100 % and displays a marker at each data point. |
| 4 | Creates three series (Q1‑Q3) that reference the worksheet ranges. |
| 5 | Enables markers (HasDataMarker = true) and sets a unique shape and colour for each series. |
| 6 | Formats the category axis, value axis, and forces the axis to show percentage values. |
| 7 | Saves the workbook as an XLSX file that can be opened in Excel, Google Sheets, or any viewer supporting the format. |
Running the program produces an Excel file with a fully formatted Line100PercentStackedWithDataMarkers chart, ready for further customization or export to PDF/Image.
Get a Free License
Want to try Aspose.Cells without limitations? Grab a temporary license from the Aspose free trial page. The temporary key removes evaluation watermarks and lets you explore all charting features.
Line100PercentStackedWithDataMarkers Chart: Free Resources
- Developer’s Guide – https://docs.aspose.com/cells/net/
- Online Excel Editor – 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
The Line100PercentStackedWithDataMarkers chart is ideal for visualizing proportional data while emphasizing individual data points with markers. Aspose.Cells for .NET makes creating, configuring, and exporting such charts straightforward and fully programmatic. Use the provided code as a starting point, adapt the data source, and apply additional styling to match your reporting needs.
For any questions or further assistance, visit the Aspose.Cells support forum.