ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   X-Axis word wrap (https://www.excelbanter.com/charts-charting-excel/231726-x-axis-word-wrap.html)

JGreg7

X-Axis word wrap
 
Is there a way to turn off the word wrap on the x-axis labels?

I have labels that are relatively long 2-3 words each, but I am not able to
find a way to keep the text from wrapping. When a label wraps, it tends to
overlap the next labels.

I have plenty of room, but when I resize the chart, at seems to size of the
x-axis label area moves proportionally. Can this area be enlarged?

Andy Pope

X-Axis word wrap
 
Hi,

You have very limited control over the layout of the axis labels.
If you use the ChartArea format dialog you can uncheck the Auto Scale option
on the Font tab. This will stop the font changing when you resize the chart
and or plot area.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"JGreg7" wrote in message
...
Is there a way to turn off the word wrap on the x-axis labels?

I have labels that are relatively long 2-3 words each, but I am not able
to
find a way to keep the text from wrapping. When a label wraps, it tends
to
overlap the next labels.

I have plenty of room, but when I resize the chart, at seems to size of
the
x-axis label area moves proportionally. Can this area be enlarged?




All times are GMT +1. The time now is 07:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com