Excel Chart Label Line Break

When adding labels to a chart sometimes you need a line break. Well it is possible.

Have a look at the market share chart below.

The labels work well because the bar sizes are fairly even.

What if they weren’t?

This solution won’t work in all cases because sometimes the label just won’t fit in the space.

But in this case, we can use a line break to make it look better.

If you select the last label and press Ctrl + 1 (use the 1 on the keyboard, not the numeric keypad).

In the task pane that opens on the right side of the screen select the last option at the top, then click the Separator drop down and choose (New Line).

 

The result is shown below.

As I mention this won’t work in all cases, but it might help in some cases.

You may want to change all the labels to be consistent.

Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.