Data Layout - Do you take advantage of vertical text to avoid lots of thin columns?

Last updated by Jeoffrey Fischer [SSW] about 1 month ago.See history

When a report has many columns and each column contains small amount of data, it is a good idea to use vertical text for the column headers.

By changing the WriteMode of a text box from:

 lr-tb (left to right, top to bottom)


 tb-lr (top to bottom, left to right)

...your text will become vertical, and you save lots of space.

Figure: Bad example - Not using vertical text for headings, when you have lots of thin columns

Figure: OK example - Not using ticks and crosses

Take it to the next level by using emojis in your report.

Figure: Good example - Use emojis to improve the quality of your report

Emojis can add visual interest and make your report more engaging and easier to interpret at a glance.

Note: Microsoft have not given us the option of having the vertical text bottom to top. It would be easier to read. This suggestion has been added to Suggestions for Microsoft RS.

We open source. Powered by GitHub