Mood:
brightTopic: EXCEL2007 TIPS
Excel 2007 allows you to easily add or change chart titles related to spreadsheets you‘ll be creating or sharing. Excel also lets you create links within your chart titles that reference back to specific cells within a worksheet. Pretty neat huh! In this short illustrated tutorial we’re going to show you how to quickly change a chart title (assuming you already know the basics of creating charts using Excel 2007’s chart wizard). Ready? Okay! To change a chart title do the following:
Step 1: Left-click the chart (with your mouse once) that you wish to modify the title to.
Step 2: Left-click the Layout tab on the Ribbon once, then left-click the Chart title icon once.
Step 3: An options list will appear. Choose option Above Chart.
Step 4: Edit the Title text box to reflect the custom title you want. Simply left-click inside the text box and hold down the left mouse button while you drag your mouse from left to right in order to highlight text. Hit the backspace or delete key on your keyboard and replace the title with one of your choice.
Step 5: Now mouse over your new chart title and right-click it once with your mouse. A context menu will appear. Use it to format your new chart title as far as font size and changing the font color, font type, etc.
Hint: Whenever chart titles are linked to reference data within cells and the cell contents are modified, Excel 2007 automatically updates any corresponding chart titles to reflect these changes.
Note: You can also change the Axis titles, reposition the location where the legend appears within the chart, turn on or turn off data labels, change the orientation of data tables and more with options which appear in the Labels category.
Did you enjoy this post?
Recommend www.theqbicle.com to a friend!
Copyright 2007-2009 The Q-bicle. All rights reserved.
The Q-bicle neither warrants expressly, written or otherwise, neither is liable for any representations in content, delays or errors in content, nor actions taken due to content
