You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser.
آموزش کامل Excel 2003 -EN
[h=2]Creating a Chart
[h=3]Creating a chart sheet
Sometimes, you may want to create a chart and place it on a separate sheet in
the workbook. This is called a Chart Sheet. Chart sheets can make your
charts stand out, particularly when working with complicated spreadsheets.
[h=2]Creating a Chart
[h=5]To Move an Embedded Chart to a Chart Sheet:
- Create an embedded chart.
- Select the chart to be moved to a chart sheet.
- Choose Chart
Location from the menu bar.
- In the Chart Location dialog box, select the As a new sheet radio button.
(The As object in radio button adds the chart as an embedded object on the worksheet.)
- Click the OK button. The chart is displayed on a separate Chart Sheet in the Workbook.
You can also use the Chart Location dialog box to rename the Chart Sheet.
[h=2]Creating a Chart
[h=3]Challenge!
- Open your Monthly Budget file.
- Type your income for the month of March in D17.
- Type your expenses for the month of March in the appropriate cells of Column D.
The
Total Expenses and
Savings will be calculated for you because of the formula in each cell.
Create an
embedded Column Chart using the expense data for the months of January and February.
Important Note: Do not include the data for rows 16 through 18 and do not include the data for the month of March.
Create a title for your chart and name it
My Budget.
- An Example:
- Save and close the document.
[h=2]Moving, Resizing, and Deleting Charts
[h=3]Introduction[h=4]By the end of this lesson, learners should be able to:
[h=2]Moving, Resizing, and Deleting Charts
[h=3]Moving a chart
An embedded chart can be moved anywhere on a worksheet. The easiest
way to move a chart is to drag it around the worksheet.
[h=2]Moving, Resizing, and Deleting Charts
[h=5]To Move a Chart:
- Click anywhere on the white space in the chart and use the cursor
- to drag the chart anywhere on the worksheet.
- Release the mouse button to place the graph in its new location.
[h=2]Moving, Resizing, and Deleting Charts
[h=3]Resizing a Chart
Charts can be resized-made larger or smaller-to fit on a worksheet. Chart Titles are sized
in proportion to how large or small you make the chart. And within the Chart Area, the Legend
and/or Plot Area can be made larger or smaller. Chart Titles can be moved but not resized.
[h=2]Moving, Resizing, and Deleting Charts
[h=5]To Resize a Chart:
- Click anywhere on the white space of the chart area, plot area or legend you want to move or resize.
- Point the mouse to one of the Grab Handles or Resize Cursor-the
- pointer changes to a double-headed arrow-to resize the chart.
- Use the mouse to drag the sizing handle until the chart is resized to the desired size.
[h=2]Moving, Resizing, and Deleting Charts
[h=3]Deleting a Chart
Any embedded chart or chart sheet can be deleted from a worksheet. A chart sheet is
deleted in the same manner a worksheet is deleted. This section discusses how to delete an embedded chart.
[h=2]Moving, Resizing, and Deleting Charts
[h=5]To Delete a Chart:
- Click anywhere on the white space of the chart area to select the chart.
- Press the Delete key on your keyboard.
If you have difficulty deleting a chart, click anywhere outside of the chart and then select the chart again.
[h=2]Moving, Resizing, and Deleting Charts
[h=3]Challenge!
- Open your Monthly Budget file.
- Move the chart so that it is located below Row 19 and all the data.
- Resize the chart so that it is larger than its current size.
- Save and close the document.
[h=2]Editing Charts
[h=3]Introduction[h=4]By the end of this lesson, learners should be able to:
- Change the Data Series Names or Legend Names
[h=2]Editing Charts
[h=3]Changing Chart Data
When you add a chart to your worksheet, Excel creates a link between the chart and your
source data. Any changes made to the original source data are automatically reflected in the chart
[h=2]Editing Charts
[h=5]To Change Chart Values Directly in Worksheet Cells:
- Open the worksheet that contains the chart to be changed.
- Click in the cell whose value will change and type the new value.
- Press Enter to accept the new value.
[h=2]Editing Charts
[h=3]Changing Chart Data (continued) [h=5]To Add Data to an Existing Chart:
Rows or columns of data can be added to an existing chart by selecting the
Add Data option on the Chart Menu.
- Input any new Source Data into the worksheet (e.g., a new column called South America).
- Click on the chart to select it for editing.
- Choose Chart
Add Data from the menu bar.
- The Add Data dialog box appears.
- Select the cell range of new data to be added to the chart. Marching ants appear around the
- cell range. The selected cells are added to the Add Data dialog box.
- Click the OK button to add the new data to the chart.
[h=2]Editing Charts
[h=3]Changing the Chart Title
The Chart Title can be changed at any time to a name that's meaningful to you.
[h=2]Editing Charts
[h=5]To Change the Chart Title on the Chart:
- Click on the Chart Title.
- Click anywhere in the title name and make any changes to the text.
- Click anywhere outside of the title to apply your changes.
[h=2]Editing Charts
[h=3]Changing the Data Series Names or Legend Text
Data Series Names and Legend Text are changed in much the same
manner as when you changed Chart Values in the worksheet.
[h=2]Editing Charts
[h=5]To Change the Data Series Names or Legend Text on the Worksheet:
- Click the cell that contains the Data Series name or Legend that you want to change.
- Type the new name.
- Press the Enter key to add the new name to the chart.
[h=2]Editing Charts
[h=3]Changing the Chart Type
There are 14 different types of charts in Excel 2003, and, with each chart type, there can
be several variations. You can see that you can create any number of different
charts. The Chart Type can be changed at any time with a couple of clicks of the mouse.
