Cognos 10 Report Studio: Every second axis label missing

I made a simple vertical bar chart that I changed it to horizontal so that axis labels would be easier to read. Some of the labels were quite long and I had manually set break after 200 characters. That way whole label would be shown. But changing chart to horizontal, I lost every second axis label!

I read cognos help troubleshoot about labels but it wasn't so clear what I need to do with my report. I share my solution here if somebody has same problems with the labels. Again, texts in the pictures are in Finnish but I wrote instructions also in English.

[1] Go to axis labels properties and set options so that you don't allow skipping but either rotation or stagger is allowed. I chose to allow stagger:
Allow 45 Degree Rotation / Salli 45 asteen kierto --> No / Ei
Allow 90 Degree Rotation / Salli 90 asteen kierto --> No / Ei
Allow Stagger / Salli porrastus --> Yes / Kyllä
Allow Skip / Salli ohitus --> No / Ei

Axis properties - labels options

In my case this wasn't enough because I had set size to the chart and there wasn't enough space for the labels. First I tested it so that I took away all the chart size settings but it didn't help. (I didn't make any changes to the report page settings.) But I find the solution:

[2] If the first step didn't help yet, set the size of the chart big enough for the labels. I needed to set chart height to 600px and after that all the labels appeared.

Size and overflow / Koko ja ylivuoto

Cognos 10 Report Studio - Rotate x-axis labels (legacy charts)

I made a report with a couple of charts in it, but the x-axis labels of the chart puzzled me. At first I couldn't find where I can modify the x-axis labels to be in a 90 degrees angle in all of those charts. Some of the charts had labels rotated 45 degrees, some 90 degrees and some of the labels were just horizontal. Now that I have solved it I want to share it :) . I add terms used in Finnish language Report Studio 'cause I think those translations used in it are often strange.

[ 1 ] Click category axis / luokan akseli in the chart
[ 2 ] In the properties list under General / Yleinen modify Label control / Nimen ohjausobjekti property from Default / Oletus àAutomatic / Automaattinen

Voilà! All the rotation properties are shown and you are able to set label rotation, eg. allow 90 degrees rotation.

NOTE: this applies to legacy charts.

MS SSRS - Sorting chart axis labels

In the beginning I had difficulties to remember where to find sorting options for the chart axis labels. Clicking around chart area and checking properties got to my nerves but then I decided to write it down for the future and then I begin to remember. I thought this would be useful post to some others too. In this example I add sorting to x-axis "finished_month".

[ 1 ]   Click over x-axis labels so that x-axis category field is seen
[ 2 ]   Right-mouse click open  Category Group Properties and add sorting.
 

x-axis labels - sorting

Notice...

[ 3 ]   It doesn't show anything at Chart Member Properties: SortExpression box. You have to click it open to see the sorting options for that Chart Member.