Copyright (c) Newday Com. Ltd. All rights reserved-2001-2008
 

                                                      

By the end of this lesson, learners should be able to:

  • Format the chart title
  • Format the chart legend
  • Format the axis

Formatting the Chart Title

The Chart Title can be formatted to change color, pattern, typeface, size and alignment using the Format Chart Title dialog box.

To format the chart title:
  • Select the Chart Title.

    Select the Chart Title
  • Click the Format Button on the Chart Toolbar (or double click the Chart Title).

    Chart Toolbar
  • The Format Chart Title dialog box contains three different tabs-Patterns, Font and Alignment-that can be used to format the Chart Title.
  • The Patterns tab lets you define borders and fill colors (see lesson 13).
  • The Font tab lets you define Font, Font Style, Size and Color (see lesson 11).
  • The Alignment tab lets you define horizontal and vertical cell placement, as well as text orientation (see lesson 11).

    Format Chart Title Dialog Box
  • Click the OK button to accept the Chart Title format changes.

Formatting the Chart Legend

The chart legend displays very useful information about the chart. Like a roadmap, the Legend identifies what different colors or objects represent in the chart. The Chart Legend, like the Chart Title and Category Axis Labels, can be formatted to your liking.

To Format the Chart Legend:
  • Press the show/hide legend button on the Chart Toolbar to turn on the Legend display. (This button acts like a toggle by turning the display on or off.)

    The Legend Button on the Chart Toolbar
  • Click to select the Chart Legend.
  • Click the Format Button on the Chart Toolbar (or double click the chart legend).

    Chart Toolbar
  • The Format Legend dialog box contains three different tabs-Patterns, Font and Alignment-that can be used to format the Chart Title.
  • The Patterns tab lets you define borders and fill colors.
  • The Font tab lets you define Font, Font Style, Size and Color.
  • The Placement tab lets you define the location where the Legend will appear on the chart.

    Format Legend Dialog Box
  • Click the OK button to accept the Chart Legend format changes.

The only way to change the actual text that appears in the Chart Legend is to change the Source Data in the worksheet.

Formatting the Axis Labels

We've previously made reference to a Y-axis and an X-axis in Excel. In Excel, a graph represents a data in two dimensions. The number of items sold in January is data on two dimensions: number of items and month. The number of items might be plotted on one axis, Y-axis, while the month may be plotted on the X-axis. The Y-axis runs up-and-down on the graph. The X-axis runs left-to-right.

When formatting the Axis labels in your chart, you can adjust the numbers on the Scale of the chart as well as change font, color, and style.

To Format an Axis:
  • Click anywhere in the Axis label that you want to edit:

    Chart X-Axis

    Chart Y-Axis
  • Click the Format Button on the Chart Toolbar (or double click the chart axis).

    Chart Toolbar
  • The Format Axis dialog box contains five different tabs-Patterns, Font and Alignment-that can be used to format the Chart Title.
  • The Patterns tab lets you define borders and tick marks.
  • The Scale tab lets you define numeric intervals on the Value (Y) Axis scale.
  • The Font tab lets you define Font, Font Style, Size and Color.
  • The Number tab lets you define the format of numbers displayed in the Axis (see lesson 12).
  • The Alignment tabs let you define text orientation (see lesson 11).

    Format Axis Dialog Box
  • Click the OK button to accept the Axis format changes.

You can also use the angle axis buttons on the chart toolbar to change the angle of the value and category axis.

Changing the Data Series Color

When a chart is created in Excel 2003 you notice that color is automatically applied to the Data Series. You can keep this format or change it for each Data Series in the chart. Many different aspects of each data series can be changed, but you'll probably change the color of bars, columns, pie slices and areas most often.

To Change the Color of a Data Series:
  • Select the data series that you wish to edit.

    Data Series Color Selection
  • Click the Format Button on the Chart Toolbar (or double click the data series).

    Chart Toolbar
  • Use the Format Data Series dialog box to pick a new color.

    Format Data Series Dialog Box
  • Click the OK button to accept the Data Series color changes.

Challenge!

  • Open your Monthly Budget file.
  • Format the chart title to Verdana, size 12 font.
  • Select the show/hide legend button until the legend is visible on the chart.
  • Format the legend placement so that it is to the left of the chart.
  • Format the y-axis so the currency amount has a dollar symbol ($) in front of it.
  • Modify the color of the January data series so that the January column appears GREEN.
  • Save and close the document.
Back Next

NOTICE BOARD 1
 Student should make sure to login to class discussion board to view the neccessary information about his or her progress.
 Don,t forget to log out when you are about to leave the class

NOTICE BOARD 2
Students Should not forget to send his or her registration password and User name to newday.com@gmail.com
For future refrence.
NOTICE BOARD 3
Student should make sure to subscribe to newsletter of this site for useful information.
MORE ADVANCE COURSE
 Microsoft Access
 Peachtree Account
 Adobe Photoshop
 Programming
ENGINNERING COURSE
 Café Management
 Repair and Maintenance
 Electronic Basic
 Networking
 

=> Do you also want a homepage for free? Then click here! <=