How to create TreeMap chart
Possible Usage Scenarios
A treemap chart provides a hierarchical view of your data and makes it easy to spot patterns, such as which items are a store’s best sellers. The tree branches are represented by rectangles and each sub-branch is shown as a smaller rectangle. The treemap chart displays categories by color and proximity and can easily show lots of data which would be difficult with other chart types.
TreeMap chart
After running the code below, you will see the TreeMap chart as shown below.
Sample Code
The following sample code loads the sample Excel file and generates the output Excel file.
// Create an instance of Workbook | |
Workbook workbook = new Workbook("treemap.xlsx"); | |
// Access the first worksheet | |
Worksheet worksheet = workbook.Worksheets[0]; | |
// Add a Treemap chart | |
int pieIdx = worksheet.Charts.Add(ChartType.Treemap, 5, 6, 20, 12); | |
// Retrieve the Chart object | |
Chart chart = worksheet.Charts[pieIdx]; | |
// Set the legend can be showed | |
chart.ShowLegend = true; | |
// Set the chart title name | |
chart.Title.Text = "TreeMap Chart"; | |
// Add series data range(D2:D13,actually) | |
chart.NSeries.Add("D2:F13", true); | |
// Set category data(A2:A13 is incorrect ) | |
chart.NSeries.CategoryData = "A2:C13"; | |
// Show the DataLabels with category names | |
chart.NSeries[0].DataLabels.ShowCategoryName = true; | |
// Fill the PlotArea area with nothing | |
chart.PlotArea.Area.FillFormat.FillType = FillType.None; | |
// Save the Excel file | |
workbook.Save("out.xlsx");; |