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


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
 
Ad

Advertisements

G

Guest

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
 
Ad

Advertisements

J

Jon Peltier

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top