cannot format axis labels

I'm working with Office 2013, which doesn't seem to allow the user to format axis labels in charts. The text box for each label is aligned to the axis, but within each text box the words are centered. I want everything to be justified against the axis (right justified).

Excel produces labels that look like this:

              |--------------------------

  blahdi  |

   blah    |                [data]

  blaahh |
              |--------------------------

              |

      nadi |                 [data]

      nah  |

              |--------------------------

              |

     ta da |                [data]

              |   

              |--------------------------

When they should look like this:

              |--------------------------

   blahdi |

      blah |                [data]

  blaahh |
              |--------------------------

              |

      nadi |                 [data]

       nah |

              |--------------------------

              |

     ta da |                [data]

              |   

              |--------------------------

But I cannot find a way to make things look the way I want.

My workaround has been to abbreviate the labels so that they fit on one line whenever possible, but some labels just need a lot of long words.

So far none of my readers have cared about these formatting details, but surely the user should be able to adjust the formatting of labels in charts!!! Any advice on other workarounds would be welcome.

|
Answer
Answer

Hello,

unfortunately, axis labels on a horizontal bar chart cannot be right-aligned. I know it's maddening, but there simply is no setting. 

As a workaround you could use data labels and assign each data label the address of the cell with the label text. 

Data labels can be justified. See this screenshot:

___________________
cheers, teylyn
 
Community Moderator
www.teylyn.com

5 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated April 15, 2021 Views 5,651 Applies to: