question

gmj-4555 avatar image
0 Votes"
gmj-4555 asked ·

Excel 2019 - hw does one left-justify the text in an Excel horizontal bar chart axis label?

Environment
• Windows 10 Enterprise (1909) 64-bit
• Excel 2019 (part of Office Professional Plus 2019)

How graphic was created
• Highlight desired data in Excel spreadsheet
• From Excel ribbon
- Insert chart
- Bar
- 100% Stacked Bar

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. A web search yields questions about this issue but no solutions.

How does one left-justify the text (as shown in the second image below)?

Image 1. How Excel generates the graphic …
15621-image-1.png

Image 2. How I’d like the graphic to appear – i.e., text in the row labels is left-justified (or right-justified) …
15593-image-2.png




office-excel-itpro
image-1.png (44.2 KiB)
image-2.png (26.5 KiB)
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

emizhang-msft avatar image
0 Votes"
emizhang-msft answered ·

I tested this problem and I found you cannot align the content to left, this is by default behavior in Excel.

· 4 ·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@emizhang-msft - Thanks for your response!

When I was researching an answer to this formatting question (prior to submitting my question), I found folks asking the same question all the way back to Excel 97 ... and there were a lot of such questions posted!

I would like to suggest that Microsoft Office product development consider adding the ability to format (at least left- and/or right-justifying) the label area text box to the feature list. Clearly, lots of folks have been struggling to try to do this.

For a work-around in my own case (and how I created the Image 2 included in my question), I created an image overlay to address the problem. I.e., I copied the Excel graphics into a Word document (as objects) and then created an image with the left-justified text and overlaid it in Word.

The Excel default was just too difficult for committee members to deal with ... and so I got pushback on the default formatting.

Thanks!

0 Votes 0 ·

You can give the feedback to Microsoft uservoice forum, this is a way for Microsoft collect information and feedback of products from users.


0 Votes 0 ·

Thank you for the tip about user voice.

I have uploaded my suggestion, https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/41100292-add-horizontal-alignment-to-the-excel-2019-format

Hope it gets lots of votes and that Microsoft chooses to implement it! :-)

0 Votes 0 ·
Show more comments
alms avatar image
0 Votes"
alms answered ·

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.


·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.