Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Why doesn't the Format Painter work for Excel chart titles?
Why doesn't the Format Painter work for Excel chart titles? When I highlight
a chart title or axis title, the Format Painter remains grayed out. Without this utility, I don't know how to copy one chart title to another chart title without losing all the text formatting, which is extensive in my case (math symbols etc.) Thanks for any suggestions! ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...excel.charting |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Why doesn't the Format Painter work for Excel chart titles?
Hi:
You can highlight the Title and via the Format menu u can change colour, etc Since you want to copy to other charts, it may be interesting to know you can link yr title to a cell in your worksheet. I don't know whether it works with your formula - is it a picture? HTH, GL, Henk "trilepton" wrote: Why doesn't the Format Painter work for Excel chart titles? When I highlight a chart title or axis title, the Format Painter remains grayed out. Without this utility, I don't know how to copy one chart title to another chart title without losing all the text formatting, which is extensive in my case (math symbols etc.) Thanks for any suggestions! ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...excel.charting |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Why doesn't the Format Painter work for Excel chart titles?
Copying character-by-character formatting is a tough job in Excel text
elements. The best bet might be to use a text box instead of the usual chart title, and perform a regular copy and paste, not just of the formats. Even if you tried using the format painter on a pair of textboxes, the formats which are copied are the ones for the entire textbox. The character by character formatting overrides are not captured by the format painter. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "trilepton" wrote in message ... Why doesn't the Format Painter work for Excel chart titles? When I highlight a chart title or axis title, the Format Painter remains grayed out. Without this utility, I don't know how to copy one chart title to another chart title without losing all the text formatting, which is extensive in my case (math symbols etc.) Thanks for any suggestions! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Format - Format Transfer To Chart | Excel Discussion (Misc queries) | |||
pivot chart format | Charts and Charting in Excel | |||
Format decimal controls do not work | Excel Discussion (Misc queries) | |||
exporting a chart to gif format using COM (Excel v11 and .net) | Charts and Charting in Excel | |||
Format Painter button problem | Excel Discussion (Misc queries) |