I have a grouped bar chart where one of the axis has very long labels. The labels are cut and replaced by ...
I saw that there is an option tickvaluefitpolicy = rotate, but I am not sure where to put the option. I have tried on the colaxis, but it doesn´t work.
Here is an example:
if region = 'EAST' then text = 'This is the first really long ';
else text = 'This is the second really long';
if region = 'EAST' then text = 'This is the third really long';
else text = 'This is the fourth really long';
FITPOLICY only comes into play when/if the axis labels don't fit. (FITPOLICY has no impact on the PANELBY text.) So, for example, if I modify your program to use FITPOLICY, it will only rotate the axis value labels if they are too long to fit (which I forced them to be too long with a user-defined format.)
When I use a too long PANELBY value, then I do see the ... ellipsis if the text is too long. I used a variety of different strings and you can see that the number of characters in the PANELBY cell will depend on how wide the letters/numbers are and how many characters will fit, based on the current font being used. You could probably change the font being used for the PANELBY text with a style template change, but I fear that you will run the risk of having the text too small to read.
if region = 'EAST' then text = 'abcdefghijklmnopqrstuvwxyz1234567890';
else text = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890';
if region = 'EAST' then text = 'xyxyxyxyxyxyxyxyxyxyxyxyxy1234567890';
else text = '1234567890123456789012345678901234567890';