View Single Post
  #6   Report Post  
Tushar Mehta
 
Posts: n/a
Default

If the text box can be colocated with the chart title, create a
composite title cell. Suppose the actual title is in B1 and the textbox
content is in A1, then in C1 enter =A1&char(10)&B1. Now, use C1 for the
chart title.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005

In article .com,
says...
Re-reading my post, it seems to be a little winded and not sure if I am
clear enough. The answer to the following question should give me the
help I require.

How do I make a text box behave the exact same way a chart title does
when copying the data sheet and the related chart?

Thanks again.
CaliberX