How to rotate the labels

There might be cases where you might need to change the alignment of labels for various reasons (the labels might not be clear, visibility is lost, data truncation, labels might be lengthy, etc). For suppose we have  the below report



If you want to show all the months on the above chart we need to first change the alignment because there will not be enough space to accommodate all the labels. So, to do this we just need to right click on the axis as shown below and select "Format"



On selecting the Format.... option you can change the alignment in the format window which will be seen on the left most. Here you need to go to the alignment dropdown and select the required option. For now, since the requirement is to show the label upside down we need to select "Up" as shown below:


Once you select the "Up" option then the labels are aligned as below:


Hope this helped you.

Happy learning!!!


No comments:

Post a Comment