Category axis labels

[Former Member]

Hi

Can anyone tell, can I manually (directly or indirectly) rotate those labels? By default, when the label text doesn't fit into 'cell' it is displayed diagonally. But I need to orient them vertically so that letters will be rotated 90 degrees (not positioned 'horizontally' and in vertical order, what is provided by selecting "Vertical Lettering")

I use WEBI Version 14.0.4

[Former Member]

can you post the screen?

[Former Member]

I don't see how it it could be useful, but I did it.

 

On the screen you can see currently displayed labels (diagonally). I need them to be oriented verticaly, but letters must by rotaed 90 degrees. Something like this:

[Former Member]

Hi Kirill N

If you are using BI 4 then just make sure the category axis is set to automatic and it should automatically translate to vertical display or slant display depending on the number of segments in the chart and its width. I think there is currently no setting to orient for the column chart Try to split the object value into two variables and then use on the report it should give you your desired layout

For Example : for Dec 29

Var 1 = Substr(Dec 29,1,3) will give you Dec

Var 2 = Substr(Dec 29, 5,2) will give you 29

use these dimension in your chart you should see the below result

Hope this Helps

[Former Member]

Hi Tauseef Ali Mir

Splitting will not help, because if you will try to split DAY and MONTH from the days of single month (for example December) you will get December aggregated on category axis. And its not an option for me.

I tried to 'play' with chart size, number of sections and so on, but I didn't get what you get. I'm getting slant display (or horizontal ofc) always, no matter what width chart has. Can you screenshot 'Category Axis' options from 'Format chart' window? Maybe I'm missing something and can't get it. I would really appreciate it.

Thanks for detailed answer

[Former Member]

Hi Kirill,

First think is your data should not be aggregated at the month level it will happen if you use only VAR1 which i mentioned above you need to actually be using both VAR1 and VAR2 in the Chart which should break the measure by each day in the month.

I am creating a table first the first column is month, Second the day and third the measure right clicking on the table and choose convert to Column Chart and by default it comes up with the format i am showing above. I have attached snapshot of the category axis properties.

Hope this Helps

[Former Member]

Hello again

Still no success.

While making some experiments from your guide, I came across some strange 'bug'. Labels on Y-axis doesn't have grid! And I can't make them have it. Background can be painted, but grid doesn't appear no matter what I do with its color. I feel like this is causing problems with orientation.

Maybe, any thoughts on this problem?

PS: Again, thanks for helping!