How can I have multiple fonts in a legend?

[Becky]

I need to have part of my legend be in italics and part in arial. In the
source code it is correct, but in the chart it is all in arial. I tried
inserting a texbox, but it doesn't line up exactly. Any suggestions?

 

[Andy Pope]

Hi,

The font for the legend can not be formatted for specific entries or
parts of an entry. Textboxes or data labels with the legend key
displayed are the normal work around for fancy legends.

Can you explain further the 'line up' problem you have with text boxes?

Cheers
Andy

 

[Becky]

Thanks Andy. I had tried to insert a texbox for part of the legend, which
resulted in the text not lining up exactly. Instead I just covered over all
the original legend with one text box and it worked fine. Thanks for you
help!

Becky

 

[Tushar Mehta]

No need to "cover up" the original legend. Instead, just delete it:
select the legend and press the Delete key.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Jon Peltier]

Unless of course you want to retain a legend-like appearance complete
with legend entries

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______