Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Changing text formats on a chart linked to a spreadsheet
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Changing text formats on a chart linked to a spreadsheet
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 _______ "Roger B." wrote in message ... 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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Changing text formats on a chart linked to a spreadsheet
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 "Jon Peltier" wrote in message ... 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 _______ "Roger B." wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro linked to text or an object | Excel Discussion (Misc queries) | |||
Changing case on text in an existing spreadsheet | Excel Discussion (Misc queries) | |||
do not chart cells linked from worksheets that are blank | Charts and Charting in Excel | |||
Changing chart orientation | Charts and Charting in Excel | |||
Why do my text boxes disappear from my chart when I click out? | Charts and Charting in Excel |