Changing text formats on a chart linked to a spreadsheet

  • Thread starter Thread starter Roger B.
  • Start date Start date
R

Roger B.

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
 
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
 
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
 
Back
Top