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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |