excel2007.Tips.Net Welcome toExcel2007.Tips.Net

Helpful Links

Excel 2007 Home
Tips.Net Home

Ask a Question
Make a Comment

Cooking Tips
Gardening Tips
Home Tips
Wedding Tips

Newest Tips

Changing a Link's Source

Using Conditional Formatting to Shade Rows

Editing by Moving and Copying

Making Sure Duplicate Names Aren't Entered

Applying a Conditional Format to a Full Row

Hiding Worksheet Tabs

Making Cells Flash

 

Changing Fonts Used in Charts

Summary: When formatting a chart, you might want to change the characteristics of the font used in various chart elements. This can be easily done using formatting techniques you may already know.

When creating a chart in Excel, you can add various elements to the charts, such as titles or data labels. Excel allows you to change the font used to display these elements, if you desire. You can change fonts for these elements individually. To do this, use these steps:

  1. Make sure your chart is visible on the screen and you have selected it. (You do this by clicking on the chart.)
  2. Select the text element whose font you wish to change. For instance, if you want to change the chart's title, click on the title. Excel displays small black squares around the element; this lets you know it is selected.
  3. Display the Home tab of the ribbon.
  4. In the Font group, use the available tools to specify the font characteristics for the element you selected in step 2.

Related Tips:

More Power! For some people, the prospect of creating Word macros can be scary. WordTips: The Macros can help you conquer your fears and you'll discover you're much more confident and productive as you make Word do exactly what you want. This is an invaluable source for learning macros. You are introduced to the topic in bite-sized chunks, pulled from past issues of WordTips. Learn at your own pace, exactly the way you want. Check out WordTips: The Macros today!