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.
Finally found the answerFor those of you who just want to this one!resize vertical Axis: (works in O365 for sure).
DO NOT click on the Vertical Axis Text Box. DO CLICK on the top of the chart area (this is called the "Plot Area") (without clicking the data graph itself known as the "Series" data) Then select the ellipses in the upper left. Resize the Plot Area, and Resize, the Vertical Axis will adjust in proportion.
Select "Plot Area" and resize to change Width of Vertical Axis.
While this doesn't likely fix the problem of the original post, it matches the subject "resize text axis box". I've added this update since on O365 this is not intuitive at all.
I have trying to solve the horizontal axis descriptions cut off by box for an hour. Google search no help. Here is a work around I figured out. Click in chart. Click on Design in Chart Tools. Click on Quick Layout. There is a picture of a layout with boxes directly below a bar chart. Select that and your X axis descriptions fit in the boxes.