How do I set up horizontal category labels to wrap in ctg space?

[kaa_63]

Hi,

in excel 2003 I had no problem with this issue. I am building a stacked bar
chart, diplaying values for two years, on a series of categories each
described in few words. On the chart, the first row of labels near the
horizontal axis is represented by years, 2 numeric values. The second row
should be for the hort tatement descibibng the category. In excel 2003 this
was automatically wrapped, but in 2007 is not! Is there a fix for this, or i
do have to go back to 2003?

Thanks!

 

[Jon Peltier]

You can enforce line wrapping by using Alt+Return in the cells, but you
would have to do this manually when the chart width changed or when a
different number of items had to be included.

This is one of the ways Excel 2007 charting differs from its predecessors.
Together they encourage me to keep my real work in Excel 2003.

- Jon

 

[kaa_63]

Thanks a lot for your precious time, I know very well Peltier site, where I
found a lot of support in the last 3 years.

This is a good solution, to force line wrapping, however, in my application
is not quite acceptable, because my categories' labels are coming via a
formula, from another, worksheet, where changing text appearance is not
desirable.

So, sadly to say, I'm preparing to switch back to 2003.

But no hopeless, as while writing these I have discovered that in another
worksheet, in similar conditions, labels wrapped automatically... still not
succesfull to replicate in original work.

 

[Jon Peltier]

Maybe the original chart is corrupted. Judging from the frequency of related
problems posted here, this seems to happen sometimes to charts in Excel 2007
which began life in an earlier version.

- Jon

 

[PatK]

This is a major problem for me in Excel 2007. How could they have missed
this? Big SNAFU.

If anyone ever finds a cure, let me know, too!!! ;-)

PS..is there a service pack planned (ack!)

Patk