TreeMap DataLabel issue

Professionalize.Discourse · February 17, 2025, 7:51am

It seems you are experiencing an issue with the visibility of data labels in your TreeMap chart. To address this, you may want to ensure that the data labels are properly formatted and enabled for the data points in your chart.

In Aspose, you can format the data points of a TreeMap chart using specific classes and methods. Here are some steps you can follow to troubleshoot and potentially resolve the issue:

Access Data Points: Use the IChartDataPointLevelsManager to access the data points of your TreeMap chart. This manager allows you to work with multi-level categories.
Format Data Labels: Each data point can be formatted using the IChartDataPointLevel class. You can access the data label settings through the getDataLabel method of this class. Make sure that the data labels are set to be visible.
Set Data Label Text: You can define what text should be displayed for each data label. For example, you might want to display the series name or the category name.
Check Visibility Settings: Ensure that the visibility settings for the data labels are enabled. Sometimes, data labels may be hidden due to specific chart settings.

Here is a sample code snippet that demonstrates how to set the data label for a data point in a TreeMap chart:

// Assuming you have a reference to your chart
IChartDataPointLevelsManager levelsManager = chart.getChartDataPointLevelsManager();
IChartDataPointLevel dataPointLevel = levelsManager.getDataPointLevel(0); // Access the first level

// Set the data label for the data point
dataPointLevel.getDataLabel().setShowValue(true); // Ensure the value is shown
dataPointLevel.getDataLabel().setText("Your Custom Text"); // Set custom text if needed

Make sure to replace "Your Custom Text" with the appropriate text you want to display.

If you continue to face issues, please check the attached zip file for any specific configurations or settings that might be affecting the visibility of the data labels.

If you need further assistance, feel free to provide more details or share specific code snippets that you are using.

John.He · February 17, 2025, 8:06am

@sanjeevkumar.v
Please add the following code to the sample code to display data labels.

//Show value labels
chart.NSeries[0].DataLabels.ShowValue = true;

Hope helps a bit.

sanjeevkumar.v · February 17, 2025, 8:10am

@John.He
Thank you, but it’s not working. I’m getting the same output as before. Please provide the correct solution.

leoluo · February 17, 2025, 8:32am

Hi @sanjeevkumar.v @John.He

I used John’s solution to get the file you expected, here is the code snippet and the output file

        chart.NSeries[0].DataLabels.ShowValue = true;

        string filePath = path + "Output.xlsx";
        workbook.Save(filePath);

        //string pdfPath = @"D:\3DTreemapChart.pdf";
        //workbook.Save(pdfPath, SaveFormat.Pdf);

        string imagePath = path + "Output.png";
        chart.ToImage(imagePath, ImageType.Png);

        Console.WriteLine("Treemap chart generated successfully!");

I used your code completely, only added a line of code provided by John, and the output file is as follows.
Output.zip (10.3 KB)

Please open this xlsx file to check, excluding the different display caused by different Excel versions. Also, please confirm the version of Aspose.Cells you using. I am using Aspose.Cells version 25.2. Thank you.

sanjeevkumar.v · February 17, 2025, 9:41am

Hi @leoluo,
The chart works correctly in the Excel sheet, but when I convert it to an image, a few data labels are not displayed properly.

John.He · February 17, 2025, 10:00am

@sanjeevkumar.v
By testing with sample code on the latest version v25.2, we can reproduce the issue. Data labels are not displayed properly when converting chart to image.

We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSNET-57834

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

sanjeevkumar.v · February 17, 2025, 10:53am

Hi @John.He,
Please notify me once this issue is resolved.

simon.zhao · February 17, 2025, 12:28pm

@sanjeevkumar.v
If it’s fixed, you will be notified. Thank you for your patience.

sanjeevkumar.v · February 19, 2025, 4:59am

Hi @simon.zhao
Any update on this issue?

John.He · February 19, 2025, 5:37am

@sanjeevkumar.v
Please allow us some time to evaluate and analyze it in detail. In normal support here, we deal with issues on a first come, first served basis. We believe this is the fairest and most appropriate way to meet the needs of our customers. If it is not complex, we should be able to fix it soon, and the fix may be included in our upcoming release (Aspose.Cells v25.3 - planned for publication in the second week of March next month). If the issue is complex, it may take a few more weeks or even a month to resolve.

Additionally, if you purchase paid support, we will prioritize your issue so that it can be resolved earlier.

sanjeevkumar.v · February 19, 2025, 6:53am

@John.He
Okay.

John.He · February 19, 2025, 7:04am

@sanjeevkumar.v
Thank you for your feedback. We will notify you promptly once there are any updates.

leoluo · March 9, 2025, 6:42am

Hi @sanjeevkumar.v
We fixed the layout issue in TreeMap, the result is shown in the following figure. It will take effect in 25.3.
250309.png (8.6 KB)

sanjeevkumar.v · March 10, 2025, 5:01am

Hi @leoluo,
Thank you for resolving the issue. I will review it and update you accordingly

simon.zhao · March 10, 2025, 7:24am

@sanjeevkumar.v
Thank you for your patience. We will release 25.3 this week.

aspose.notifier · March 12, 2025, 1:25pm

The issues you have found earlier (filed as CELLSNET-57834) have been fixed in this update. This message was posted using Bugs notification tool by leoluo

Suriya08 · July 28, 2025, 9:38am

“Hi,
I am using Aspose.PDF version 25.7.0 , but I still have the label issue — the percentage value is being hidden. Why is this happening?”
image.png (19.1 KB)

I have attached the Image for your reference

amjad.sahi · July 28, 2025, 10:00am

@Suriya08,

I tested the following sample code using Aspose.Cells for .NET v25.7 and it works fine. The labels are shown properly with percentage values in the output image and Excel spreadsheet.
e.g
Sample code:

Workbook workbook = new Workbook();
Worksheet sheet = workbook.Worksheets[0];

sheet.Cells["A1"].Value = "Category";
sheet.Cells["B1"].Value = "Percentage";

string[] categories = { "Mentor", "Guardian", "Principal", "Dominion", "Angel", "Binder", "Visualizer", "Charmer", "Harmonizer" };
double[] percentages = { 81.91, 76.6, 75.62, 55.69, 52, 50.49, 50.49, 47.24, 38.14 };

for (int i = 0; i < categories.Length; i++)
{
       sheet.Cells[$"A{i + 2}"].Value = categories[i];
       sheet.Cells[$"B{i + 2}"].Value = percentages[i];
}

int chartIndex = sheet.Charts.Add(ChartType.Treemap, 5, 0, 25, 8);
Chart chart = sheet.Charts[chartIndex];

chart.Title.Text = "3D View of Purpose, Passion & Potential";
chart.Title.Font.IsBold = true;
chart.Title.Font.Color = System.Drawing.Color.White;
chart.Title.Font.Size = 14;

chart.NSeries.Add("B2:B10", true);
chart.NSeries.CategoryData = "A2:A10";

Series series = chart.NSeries[0];
for (int i = 0; i < series.Points.Count; i++)
{
                DataLabels labels = series.Points[i].DataLabels;
                labels.ShowCategoryName = true;
                labels.ShowValue = true;
                labels.Text = $"{categories[i]}, {percentages[i]}%";
                labels.Position = LabelPositionType.Center;
                labels.Font.Color = System.Drawing.Color.White;
                labels.Font.IsBold = true;
}

chart.PlotArea.Area.ForegroundColor = System.Drawing.Color.White;
chart.PlotArea.Area.FillFormat.FillType = Aspose.Cells.Drawing.FillType.Solid;

chart.ShowLegend = false;
chart.Title.IsVisible = false;


chart.ChartArea.Border.IsVisible = false;
chart.PlotArea.Border.IsVisible = false;
chart.ChartArea.Area.FillFormat.FillType = Aspose.Cells.Drawing.FillType.None;
chart.PlotArea.Area.FillFormat.FillType = Aspose.Cells.Drawing.FillType.None;

//Show value labels
chart.NSeries[0].DataLabels.ShowValue = true;

string imagePath =  @"e:\\test2\\out_net1.png";

chart.ToImage(imagePath, ImageType.Png);
workbook.Save("e:\\test2\\" + "out_net1.xlsx");

Please find attached the output image and Excel file for your reference.
files1.zip (19.3 KB)

Could you please share a sample (runnable) code same as above to reproduce the issue on our end, we will check your issue soon.

Suriya08 · July 28, 2025, 11:58am

I tried the code you provided, but it’s not working for some specific arrays.
Please try applying the following values to your code — it will reproduce the issue:
Values.docx (11.2 KB)

simon.zhao · July 28, 2025, 12:20pm

@sanjeevkumar.v
If the chart (area) is not wide, the data labels should be wrapped.
We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSNET-58799

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.