Add horizontal alignment to the Excel 2019 ‘Format Axis’ text options (‘Text Box’)
When one creates a horizontal bar chart from a data table, there are limited options to format the axis text box. One would think that by highlighting the label area text box and clicking on the alignment options, one could left-justify the text … nothing seems to work.
I verified with Microsoft (https://docs.microsoft.com/en-us/answers/questions/59141/excel-2019-hw-does-one-left-justify-the-text-in-an.html) that only a default behavior is possible.
Specifically, please add the ability to left-justify (or right-justify) the text. The default Excel behavior vs. the desired Excel formatting option is illustrated in the URL above (and in the attached document).
In searching the various forums for a work-around, I found that a solution to this need has been requested many times over the years.
In my case, after pasting the illustrations into Word 2019 (as objects), I had to create an image overlay to address the formatting issue … a quite tedious task in a very lengthy chart-illustrated paper.
Workaround: This is possible in Powerpoint Charts, although a bit hidden: Mark the text element, got to "Paragraph" section in the ribbon "Home" and click on the small arrow in the bottom right corner. In the dialogue, set your alignment in the dropdown of the section "General".
Another possibility, if you need to stay in Excel: You could use data labels and assign each data label the address of the cell with the label text. Data labels can be justified, as suggested by teylyn here https://answers.microsoft.com/en-us/office/forum/office_2013_release-excel/cannot-format-axis-labels/137abcec-6009-4ce4-869b-357753447e0a.