How can I have multiple fonts in a legend?

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

Guest

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?
 
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
 
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
 
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
 
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/
_______
 
Back
Top