آموزش کامل Excel 2003 -EN

[A M I R]

[h=2]Editing Charts

[h=5]To Select a Different Chart Type:

• Click on the chart to select it for editing.

• Click on the Chart Type dropdown list box and select a different chart.
• 
  
  
  

The new chart replaces that one selected for change.

​

 

[A M I R]

[h=2]Editing Charts

[h=3]Challenge!

• Open your Monthly Budget file.

• Change the dollar amount of Gas you spent in the month of February (cell C11) and press Enter to accept the new value.

Notice how the chart changes when you make that modification. Also, the values in C16 and C18 change automatically.


If you did not see the chart change, try entering another number into C11.

• Add the data for the month of March to the chart.

• Change the chart title from My Budget to whatever you wish to name it.

• Save and close the document.

​

 

[A M I R]

[h=2]Formatting a Chart

[h=3]Introduction[h=4]By the end of this lesson, learners should be able to:

• Format the chart title

• Format the chart legend

• Format the axis

​

 

[A M I R]

[h=2]Formatting a Chart

[h=3]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.

​

 

[A M I R]

[h=2]Formatting a Chart

[h=5]To format the chart title:

• Select the Chart Title.
  
  
  
• Click the Format Button on the Chart Toolbar (or double click the Chart Title).
  
  
  
• 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).
  
  
  
• Click the OK button to accept the Chart Title format changes.

​

 

[A M I R]

[h=2]Formatting a Chart

[h=3]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.



​

 

[A M I R]

[h=2]Formatting a Chart

[h=5]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.)

• 
• Click to select the Chart Legend.

• Click the Format Button on the Chart Toolbar (or double click the chart legend).
  
  
  
• 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.
  
  
  
• 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.


​

 

[A M I R]

[h=2]Formatting a Chart

[h=3]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.
​

 

[A M I R]

[h=2]Formatting a Chart

[h=5]To Format an Axis:

• Click anywhere in the Axis label that you want to edit:
  
  
  
  
  
  
  
• Click the Format Button on the Chart Toolbar (or double click the chart axis).
  
  
  

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

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



​

 

[A M I R]

[h=2]Formatting a Chart

[h=3]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.



​

 

[A M I R]

[h=2]Formatting a Chart

[h=5]To Change the Color of a Data Series:

• Select the data series that you wish to edit.
  
  
  
• Click the Format Button on the Chart Toolbar (or double click the data series).
  
  
  
• Use the Format Data Series dialog box to pick a new color.
  
  
  
• Click the OK button to accept the Data Series color changes.

​

 

[A M I R]

[h=2]Formatting a Chart

[h=3]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.

​

 

[A M I R]

[h=2]Defining Page Setup Options

[h=3]Introduction[h=4]By the end of this lesson, learners should be able to:

• Set page margins

• Change page orientation and paper size

• Create headers and footers
• Create sheet settings

​

 

[A M I R]

[h=2]Defining Page Setup Options

[h=3]Setting Page Margins

The Page Margins define where on the page Excel will print the worksheet. By default, the top

and bottom margins are set at 1 inch in Excel 2003. The left and right margins are set at .75 inch. Margin

settings can be changed to whatever you want. Different margins can be defined for each worksheet in the workbook.

​

 

[A M I R]

[h=2]Defining Page Setup Options

[h=5]To Change the Margins in the Page Setup Dialog Box:

• Select the correct worksheet.

• Choose File
  
  Page Setup from the menu bar.
  
  
  
• Select the Margins tab.
  
  
  
• Use the spin box controls to define the settings for each page margin-Top, Bottom, Left, Right, Header and Footer.

• Click the OK button to change the margin settings.

​

 

[A M I R]

[h=2]Defining Page Setup Options

[h=3]Changing the Page Orientation and Paper Size
The Page tab of the Page Setup dialog box lets you change page orientation (portrait or landscape) or

paper size (e.g., letter size or legal size). The default paper size in Excel 2003 is 8.5 X 11 inches, with

a portrait orientation (prints up and down on the long side of the page). A landscape orientation, on the

other hand, prints up and down on the short side of the page.

​

 

[A M I R]

[h=2]Defining Page Setup Options

[h=5]To Change Page Orientation:

• Select the correct worksheet.

• Choose File
  
  Page Setup from the menu bar.

• Click on the Page tab.
• 
  
  
  
• Choose an Orientation (Portrait or Landscape) for the worksheet.

• Select a Paper Size from the list of available paper size options that appear in the list box.

• Click on the paper size.

• Click the OK button to accept the page settings.

The Page tab of the Page Setup dialog box lets you shrink the spreadsheet data so it fits on a

specified number of pages when you print. Click the Fit to: option button and enter the desired number of pages wide and pages tall.

The Page tab of the Page Setup dialog box lets define the resolution of the print job. Print Quality

is measured in dpi, or dots per inch. High dpi provides a better print quality.
​

 

[A M I R]

[h=2]Defining Page Setup Options

[h=3]Creating Headers and Footers

Headers and Footers can be added to any worksheet, although not required. A Header is any

information that appear at the top of each page. A Footer prints at the bottom of the page. If

you want a header or footer inserted onto a page then you will have to define them. Excel 2003 defaults to no header and no footer.



​

 

[A M I R]

[h=2]Defining Page Setup Options

[h=5]To Create a Header:

• Choose File
  
  Page Setup from the menu bar.

• Select the Header/Footer tab in the Page Setup dialog box.
  
  
  
• Click the Header drop down list and select and of the predefined headers:
  
  
  
  
  
  OR
  
  click the Custom Header button to create your own header. Follow the instructions in the Header dialog box to make your entry.

• Click the OK button to return to the Page Setup dialog box.

​

 

[A M I R]

[h=2]Defining Page Setup Options

[h=5]To Create a Footer:

• Choose File
  
  Page Setup from the menu bar.

• Select the Header/Footer tab in the Page Setup dialog box.

• Click the Footer drop down list and select one of the predefined footers.
  
  
  
  
  
  OR
  
  Click the Custom Footer button to create your own footer. Follow the instructions in the Footer dialog box to make your entry.

You can insert Placeholder buttons into both the header and footer to format text, insert

page numbers, date, time, filename, or tab name. Excel replaces those placeholders with

the information each represents when the worksheet is printed. Follow the instructions in the Header and Footer dialog boxes.

​