View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default 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?