TreeMap DataLabel issue

Aspose.Cells Product Family
1

Hi,
I am facing an issue where the data labels are not visible in the TreeMap chart. For your reference, I have attached a zip file.

TreeMapCode.zip (71.0 KB)

2

@sanjeevkumar.v

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:

  1. 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.

  2. 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.

  3. 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.

  4. 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.

3

@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.

4

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

5

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.

6

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.

7

@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.

8

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

9

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

10

Hi @simon.zhao
Any update on this issue?

11

@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.

12

@John.He
Okay. :+1:

13

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

14

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)

15

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

16

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

17

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