Changing text formats on a chart linked to a spreadsheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Roger B. - 10 Sep 2006 19:21 GMT

Currently I have some text combined with formulae in a text box showing on a
chart sheet linked to a worksheet where the original info is. In the chart
sheet I would like to change the size of some of the text and add colour to
some of the text as well. The text box can be changed if there is a better
way to achieve the above.

Any suggestions would be greatly appreciated.

Roger

Reply to this Message

Jon Peltier - 11 Sep 2006 02:20 GMT

If the textbox (or other text element) is linked to a cell, you cannot
format individual characters within the text. What I have done is used
multiple textboxes, one per required format, and grouped them together to
prevent their wandering apart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______

> Currently I have some text combined with formulae in a text box showing on
> a chart sheet linked to a worksheet where the original info is. In the
[quoted text clipped - 5 lines]
>
> Roger

Reply to this Message

Roger B. - 11 Sep 2006 18:31 GMT

Hi Jon, thanks for your help. Much appreciated. Coincidently I was on your
website yesterday before receiving your reply. Small world sometimes!

Best regards,

Roger

> If the textbox (or other text element) is linked to a cell, you cannot
> format individual characters within the text. What I have done is used
[quoted text clipped - 17 lines]
>>
>> Roger

Reply to this Message