"Formatting the Excel 2007 Chart Legend"

To resize a legend box

• Click the chart legend.
• Drag one of its selection handles (legend border) to make it bigger or smaller.

To set the chart legend placement

• Select the chart, if needed.
• On the Chart Tools Layout tab, in the Labels group, click Legend icon and choose the option where you want to position the chart legend.

To format the chart legend

• Right-click the chart legend and choose Format Legend.
• From the Format Legend dialog box displayed, do the formation as needed. The available categories are Fill, Border Color, Border Styles, and Shadow.

• When finish, click Close.

To format the chart legend font

• Right-click the chart legend and choose Font.
• From the Font dialog box displayed, select the required formatting options.

• Click the OK button.

Related Topics:

Guide to Creating a Chart from Data in a Excel 2007 Worksheet
Creating and Formatting the Excel 2007 Chart Title
Step-by-step guide to Create a Pie Chart in Excel 2007?
How to Make a Histogram with Microsoft Excel 2007?

Can't find what you're looking for? Try Google Search!

Custom Search

Back to Top

You're viewing the Excel 2007 chart legend info page, click here to go back to the Home Page

Add To Your Social Bookmarks: Blink Del.icio.us Digg
Furl Google Simpy Spurl Technorati Y! MyWeb