![]() The only way I could affect Y-axis width was to make the overall chart wider or narrower, and Excel would redraw the labels. Plus, if you attempt to format the labels in the Format Axis pane, there is no setting for the label area width. Clicking and trying to drag on the sides or corners of the label area does nothing. It should also be noted that if there are too many labels to display along the allotted Y-axis space, then Excel will only display a subset of the labels, such as every other label, every third label, every fourth label, or so on.Īs far as manually adjusting the width for the Y-axis labels, we could find no way to do this. If the label contained spaces, then Excel would try to fit everything it could up to a space, and then display ellipses (.) from that point. It is interesting to note that in all instances of my testing, if the Y-axis label contained no spaces, when it got too wide, Excel simply hid the entire label. On a high-resolution monitor, I got the width to be about 80 characters by making the workbook window quite wide and then the embedded chart to be a sizeable portion of that workbook's horizontal area. (This number of characters may vary based on the version of Excel and page layout.) When it comes to embedded charts, the width displayed depends on the width of the embedded chart. The width adjustment is done to allow the full display of the longest text, up to about 69 characters on a sheet-size chart. Trevor is asking, specifically, about Y-axis label widths in bar charts.) (See Figure 1.)įigure 1. If they go vertically, from bottom to top, then that is a column chart. (Note that in Excel, a bar chart has the bars extending from left to right, horizontally. ![]() In the newest versions of Excel-specifically, the version with Office 365-Excel adjusts the width of the Y-axis labels just fine when you create your bar chart. ![]() This problem may actually be an issue related to the version of Excel you are using or, possibly, the version of Excel used to create the workbook. He wonders if there is a way to make the labels wider. Even if Trevor changes the font size, the labels will only show 7-9 characters. The labels on the Y-axis contain the names of European countries, but the label width isn't wide enough.
0 Comments
Leave a Reply. |