Wrap category names (Y axis labels) of a scatter chart?

[JayUSA]

Hi Everyone,

I've used Jon Peltier's "Dot Plotter" add-in to create a scatter chart (see attached image). I'm looking for some way to control the alignment and formatting of the category labels that appear as Y axis labels. Specifically, I'd like to set some sort of max width to be used by these category names, and have the text wrap if they exceed the max width. So far, I can't figure how to do this, and the longer the category name, the wider the space on the left used by the (all) the category names, effectively squeezing the chart.

Any ideas?

Cheers,

Jay

[Andy Pope]

If the long text is not automatically wrapping that would suggest a textbox has been used to create the labels.
You should be able to format the textboxes to wrap.

If you need more help you need to post a example file rather than image.

[JayUSA]

Hi Andy,

First of all, it's great to see that you are still active on this board. A few years back I asked a few things about who you and where you live... and I still have in mind that if I ever visit the UK it would be interesting to have a coffee with you and learn more about who you are... this Englishman who helps the entire world with their Excel problems!

Anyhow.. I just created a tiny spreadsheet and uploaded it to Excel Forum to include with a different post / thread.

I now realize that I can attach it to this post / thread too. You will see in the attached chart that my labels ARE wrapping when they reach a certain length. But I still see no way to control their formatting; for example, to make the labels right-justified.

Can you share a word of wisdom?

Cheers,

Jay

[Andy Pope]

The labels are the standard axes labels and you have very limited control over their layout.
You can add line feeds to wrap the text by adding ALT+ENTER to the text in the cells.

If you want full control you will need to create your own textboxes to use as labelling.
http://www.andypope.info/vba/Axislabel_textboxes.htm