Is it possible to force the X-axis labels onto two lines, no matter how
wide a bar chart is?

For a client, I'm creating a series of 50 bar charts showing
distribution of prices and margins in certain ranges, so the X-axis
labels are like this: "$1.00-$1.50", "$1.50-$2.00", "$2.00-$2.50" and
so on. On some of the charts, the labels are split onto two lines, on
others, they are not. The client is adamant that all the labels be on
two lines.

So far, the only option I've found is to copy the chart and paste it
into Powerpoint as an enhanced metafile; then ungroup it (twice),
delete the labels and retype them, then regroup the chart elements. Of
course this means a lot more work, which has to be repeated every time
the client changes the charts.

Is there a better way?

[Excel 2002]

Thanks.

Go to the range of cells containing the labels, and insert line breaks by
placing the cursor where desired and pressing Alt+Enter.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

"jg70124" wrote in message
oups.com...
Is it possible to force the X-axis labels onto two lines, no matter how
wide a bar chart is?

For a client, I'm creating a series of 50 bar charts showing
distribution of prices and margins in certain ranges, so the X-axis
labels are like this: "$1.00-$1.50", "$1.50-$2.00", "$2.00-$2.50" and
so on. On some of the charts, the labels are split onto two lines, on
others, they are not. The client is adamant that all the labels be on
two lines.

So far, the only option I've found is to copy the chart and paste it
into Powerpoint as an enhanced metafile; then ungroup it (twice),
delete the labels and retype them, then regroup the chart elements. Of
course this means a lot more work, which has to be repeated every time
the client changes the charts.

Is there a better way?

[Excel 2002]

Thanks.