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 !