The following image shows my current graph. The area in red is what I want to resize the text label box to in order to prevent the text from being cut off. However, I've searched everywhere for a way to resize the text label box but didn't succeed. I can resize the entire graph in Excel to show the full text of the text labels, but this becomes too broad to be displayed nicely in Word 2016 on A4 format. Ideally, I want the text label to cover about 80% of the width of the entire graph, and have the frequency bars cover the rest.
Best Answer
It is not possible to do this in Excel 2016. There is no way using built-in features to make this work. I have not tried or used any third party extensions yet, but I wasn't interested in that either.