Category Axis Area in Bar Chart Cuts Words Apart on Wordwrap

V

Viper

I have a bar chart in Excel 2000, and I need to fit a lot
of Data into a small chart area. Currently, the data is
being displayed properly, but the Category Axis Labels
are being wordwrapped and when this happens, it just cuts
a word in half. For instance, one label is 'Professional'
and it gets displayed as the following:
'Professio'
'nal'

Any suggestions at how to control this so that it doesn't
happen would be much appreciated. Thanks.

Viper
 
D

Debra Dalgleish

To help control where the labels break, you can add line breaks in the
label cells on the worksheet.

For example, in the cell that contains "Professional", type a hyphen
after the first 's', then type Alt+Enter, to add a line break.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Chart with 2 horizontal axis field (categories) 1
Pivot Chart - X-axis labels when adding data 0
can't click on series, close to Y-Axis 1
Cumulative Data Labels on Stacked Bar/Column Chart 1
Horizonal bar chart with secondary axis problem 1
Multi-level Category Axis Fails with >100 rows of data 2
Formatting in bar chart axis 1
Multi-level Category Axis Fails with >100 rows of data 0

Top