Is there any way to fix the Category Tick Lable Width?

Aspose.Cells Product Family
1

Hi,

Any one can help me out please…

I need to align 3 charts bottom in the same level exclusive of category labels since 2 charts are having long titles , so we provided 90 degrees rotation angle now displayed as vertically, but one chart is in horizontal way… The problem here was bottom scales are not aligned if some data change, for that i wanted to fix the width of the Category Tick Labels of other so then it may not disturb the alignment for data change.

Kindly find the attached screen shots.

1.I need to align the out put as mentioned in first Image.
2.But for Data Changes alignments disturbed(second Screen Shot)


Kindly respond ASAP.

Thanks & Regards,
Pushpa B.

2

Hi,


When you set the category axis’ Tick labels’ rotational angle to 0 or 90, the labels are automatically wrapped into multi-lines, so you may try to set the angle accordingly and also set the font to minimum size if possible.
e.g
Sample code:
…
chart.CategoryAxis.AutoScaleFont = true;
chart.CategoryAxis.TickLabels.RotationAngle = 90;
chart.CategoryAxis.TickLabels.Font.Size = 8;

If you still could not evaluate, kindly do post your template files ( input + output etc.) and paste your sample code (runnable) here, we will check your issue soon. Also provide us your expected file with your chart having the tick labels formatted as per you needs (you may do the task in MS Excel manually).

Thank you.