Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I set up horizontal category labels to wrap in ctg space?
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! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I set up horizontal category labels to wrap in ctg spac
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" wrote: 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! |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I set up horizontal category labels to wrap in ctg spac
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 ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "kaa_63" wrote in message ... 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" wrote: 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! |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I set up horizontal category labels to wrap in ctg spac
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 "Jon Peltier" wrote: 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 ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "kaa_63" wrote in message ... 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" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Category Axis Date Labels | Charts and Charting in Excel | |||
Format Category Labels | Charts and Charting in Excel | |||
Word wrap on the category axis | Charts and Charting in Excel | |||
Appearance two labels on category axis | Charts and Charting in Excel | |||
255 lines in value or category X labels | Charts and Charting in Excel |