Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Y-Axis Label won't let me resize it
I have a long title on my y-axis of a scatter plot (ex. Concentration (mg/L))
and excel cuts the title off after it is only partially displayed (ex. Concentr). In other versions of excel I could resize the axis label to contain all the text but it will not let me and the X-axis doesn't do the same thing it resizes itself correctly. The only alternative is to make the font so small that it is illegable. Anyone have an idea on how to fix this. I''m using MS Office 2000, if that is somehting you need to know. |
#2
|
|||
|
|||
This truncation of axis titles is a frustrating issue. It can be worked
around sometimes by upgrading video drivers and so forth, and by trying different zoom settings, font sizes, etc. In general, the title is correct in print preview and when printed, if it's any consolation. I've rarely been affected, but some people cannot escape it whatever they try. You could also replace the Y axis title with a textbox, which allows you to resize it to fit the text. In no version of Excel is it possible to resize the axis titles, chart titles, or data labels, even though they appear to be regular text boxes. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ D. Bishop wrote: I have a long title on my y-axis of a scatter plot (ex. Concentration (mg/L)) and excel cuts the title off after it is only partially displayed (ex. Concentr). In other versions of excel I could resize the axis label to contain all the text but it will not let me and the X-axis doesn't do the same thing it resizes itself correctly. The only alternative is to make the font so small that it is illegable. Anyone have an idea on how to fix this. I''m using MS Office 2000, if that is somehting you need to know. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
X axis label problem | Charts and Charting in Excel | |||
In Excel how do I label the axis of a chart with 2 sets of labels | Charts and Charting in Excel | |||
Resize chart data label | Charts and Charting in Excel | |||
Move x axis label | Charts and Charting in Excel | |||
Excel graph y axis label cut | Charts and Charting in Excel |