View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default How do I set up horizontal category labels to wrap in ctg space?

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"kaa_63" wrote in message
...
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!