Resizing Chart Titles

[iprefe...@officeformac.com]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) This seems so easy, I just can't understand why I can't make it work. Excel automatically adjusts chart title width as it sees fit. I have tried to "click and drag" and have navigated through every chart editing menu I can find to attempt to widen the text box to limit additional rows of text. There is plenty of white space on either side of my title. Nevertheless, I modified the chart to twice it's width thinking the borders of the chart were the constraint. How on earth something so simple could be so royally screwed up is beyond my capacity for words at this point.

[Bob Greenblatt]

On 1/20/10 9:41 PM, in article 59bb1...@webcrossing.JaKIaxP2ac0, "iprefe...@officeformac.com" <iprefe...@officeformac.com> wrote:

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) This seems so easy, I just can't understand why I can't make it work. Excel automatically adjusts chart title width as it sees fit. I have tried to "click and drag" and have navigated through every chart editing menu I can find to attempt to widen the text box to limit additional rows of text. There is plenty of white space on either side of my title. Nevertheless, I modified the chart to twice it's width thinking the borders of the chart were the constraint. How on earth something so simple could be so royally screwed up is beyond my capacity for words at this point.

If you select the chart title, and then in the format menu choose chart title, then text... Does that not do what you want? If not, please try to explain clearly what you are trying to make happen and what does not work.

--
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

[iprefe...@officeformac.com]

I'm trying to resize the width of the title. I cannot do this by clicking and draging or through the title format box.

[rpraje...@gmail.com]

u can change the chart area size, it'll automatically change the chart title width.

[erikbe...@gmail.com]

> u can change the chart area size, it'll automatically change the chart title width.

Unintended disinformation.
What you say is true only up to about 75 % or even less of the chart width, as the original poster also mentioned. After that, you get two lines, although there are lots of space left!