This article explains how to create a treemap chart in Excel using XlsIO.
What is a treemap chart?
Treemap provides a hierarchical view of data as clustered rectangle with a specific weighted attribute determining the size of the rectangle.
Treemap chart created using XlsIO
To create a treemap chart in Excel using XlsIO, you need to do the following steps.
Steps to create treemap chart
Create a chart object by calling the worksheet.Charts.Add method and specify the chart type to ExcelChartType.TreeMap enum value.
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.
Add the basic elements like chart title, data labels and legend with the below list of properties.
Applicable properties of treemap chart
Other property that is applicable for a treemap chart.
The following C#/ VB.NET complete code snippet shows the creation of treemap chart using XlsIO.
|Article ID:||Published Date:||Last Revised Date:||Platform:||Control:|
or the page will be automatically redirected to sign-in page in 10 seconds.