August 24, 2018
I have some long labels in charts and like to wrap the text and right align it. While it's a bit fiddly (the best option i have found is to copy it into powerpoint where you can select the alignment and then paste back - is there a better way?) i have now saved a template, but it doesn't work when there's a negative rate (as well as positive).
Any help appreciated 🙂
Moderators
January 31, 2022
The only solution I could come up with was to include line feeds (alt-enter) inside the cells with the labels and making sure that these cells are set to wrap text. Then the chart labels (both axis- and data-) will display the wrapped texts.
I've attached a very crude example to demonstrate this.
August 24, 2018
Thanks Riny, I have tried it before but when you have a lot of charts it would be so much easier if it could be done automatically. I was pleased to find a work-around a few months back which has been ok since, but this 'negative' value seems to be causing an issue (the label wraps fine if the negative entry is left off, though obviously i can't do that!).
1 Guest(s)