ChartType.BUBBLE_3_D overlapping in a chart

Hey,

I am generating a chart and using ChartType.BUBBLE_3_D to write labels for the coordinates. My problem is that sometimes, bubbles overlap and one of them can’t be read. Is there an easy way to prevent them from overlapping? Or do I have to write a full function to do that?

Thank you in advance.

@davidsimon14,

Thanks for your query.

Well, Aspose.Cells works the same way as per MS Excel when generating MS Excel charts. I guess either the chart has many labels or the labels are too long to occupy suitable space. Moreover, your chart/plot area might be so small to make all the labels visible separately. I guess you may try to set rotation angle or decrease the font size of the data labels so they could be displayed properly.

If you still find the issue, kindly do provide your sample code (runnable) or preferably a console demo application (you may zip the project prior attaching here) to show the issue, we will check it soon. Also provide your sample files (input (if any) and output file). This will help us evaluate your issue precisely to figure it out soon.

Hey. Thank you for your quick answer.

I am consolidating data from a database into the excel file, the chart is already there, but the numbers change depending on the company and the axis changes too. So I can’t know where all the labels will be lined up. I need to find a way to dynamicaly sort them and set space between them.

The rotation won’t help here, since the labels are overlapping between each other, not overlapping anything else.
The size would be a good idea, but we have already been asked to make it bigger…

I have attached the file if you want to look at it (first tab, at the bottom), it’s not really a code issue since I only copy the data inside the excel file, I barely do anything on the chart.

Consolidation.zip (54.2 KB)

Anyway I’m going to have to write a function for that, there’s nothing wrong with aspose or excel.
Thank you !

@davidsimon14,

Thanks for providing us template file and further details.

Hopefully you will find better way to cope with it and sort it out. Moreover, you may try to figure it out (based on updated/final source data for the chart) manually in Ms Excel and then make adjustments in the template file (e.g update chart objects and shapes, etc.) accordingly.