Why doesn't the Format Painter work for Excel chart titles?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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/com...5b71cab794&dg=microsoft.public.excel.charting
 
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
 
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
 
Back
Top