How to create Excel 100% stacked line chart in C#, VB.NET?

This article explains how to create a 100% stacked line chart in Excel using XlsIO.

What is 100% stacked line chart?

100% stacked line chart is a line chart in which lines do not overlap because they are cumulative at each point. In the stacked 100 line chart, the lines reach a total of 100% of the axis range at each point.This chart displays series as a line. Values are represented on the y-axis and categories are displayed on the x-axis.

100% Stacked line chart created using XlsIO

To create a 100% stacked line chart in Excel using XlsIO, you need to do the following steps.

Steps to create 100% stacked line chart

Initialize chart

Create a chart object by calling the worksheet.Charts.Add method and specify the chart type to ExcelChartType.Line_Stacked_100 enum value.

Assign data

Set a range of data from the worksheet to chart’s DataRange property. To plot the series values in column and categories in row, set chart’s IsSeriesInRows property to false.