"Formatting the Excel 2007 Chart Legend"


Excel 2007 chart legend is the little box that appears next, above or below the chart. It provides the descriptions what the different colors or patterns mean in a chart. You can so some formatting to the legend such as resize, placement, legend font and color.


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.

Excel 2007 Format 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.

Excel 2007 format legend dialog box

  • 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.

Excel 2007 font dialog box

  • 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: add to BlinkBlink add to Del.icio.usDel.icio.us add to DiggDigg
add to FurlFurl add to GoogleGoogle add to SimpySimpy add to SpurlSpurl Bookmark at TechnoratiTechnorati add to YahooY! MyWeb


Google Search:

Custom Search

Recommended Books:

Click on the image to view the details of the book.
Excel 2007 ebook
The Ultimate Guide to
Excel 2007!


PowerPoint 2007 ebook
The Ultimate Guide to
PowerPoint 2007




XML RSS
What is this?
Add to My Yahoo!
Add to My MSN
Add to Google


Enjoy This Site?
Then why not use the button below, to add us to your favorite bookmarking service?

Copyright © www.msoffice-tutorial-training.com. All Rights Reserved.