آموزش Excel 2000-EN

[A M I R]

[h=2]Moving, Resizing, and Deleting Charts

[h=3]Deleting a Chart
If you make a mistake inserting a chart, or if you would like to remove it from your document, use the delete key on your keyboard.



​

 

[A M I R]

[h=2]Moving, Resizing, and Deleting Charts

[h=5]Deleting a chart:
Click on the white space anywhere on your chart to show the selection box.

Press the delete key on your keyboard.

If you are having difficulty deleting a chart, click the worksheet outside of the chart. Now you should be able to select and delete the chart.



​

 

[A M I R]

[h=2]Moving, Resizing, and Deleting Charts

[h=3]Moving a Chart
The easiest way to move a chart is to drag it around the worksheet.

​

 

[A M I R]

[h=2]Moving, Resizing, and Deleting Charts

[h=5]To move a chart:
Click on the white space anywhere on your chart.

Use the cursor to drag your chart anywhere on the worksheet.

​

 

[A M I R]

[h=2]Moving, Resizing, and Deleting Charts

[h=3]Resizing a ChartSometimes a chart just will not fit on a worksheet. Excel makes it easy to make a chart smaller (or larger).

​

 

[A M I R]

[h=2]Moving, Resizing, and Deleting Charts

[h=5]Resizing a Chart:
Click on the white space anywhere on your chart.

Use the grab handles to resize the chart.

​

 

[A M I R]

[h=2]Moving, Resizing, and Deleting Charts

[h=3]Challenge!
Create a chart and practice the following:

• Move your chart.
• Resize your chart.
• Delete your chart.

​

 

[A M I R]

[h=2]Editing Charts

[h=3]Introduction
[h=4]By the end of this lesson, learners should be able to:
Make changes to the data presented in a chart

Format the following parts of a chart:

• Title

• Legend

• Category Axis and Value Axis

• Data Series Color

​

 

[A M I R]

[h=2]Editing Charts

[h=3]Changing the Data in a Chart
When you add a chart to your worksheet, Excel creates a link between the chart

and your source data. That way, any changes that you make to the original

source data are instantly reflected in your chart


You can also add rows or columns of data to an existing chart by selecting Add Data on the Chart Menu.

​

 

[A M I R]

[h=2]Editing Charts

[h=5]To add data to an existing chart:
Select the chart that you wish to edit.

Choose Chart

Add Data.

Enter the range that you would like to add in the Add Data

dialog box, or select the range of cells that you want to add to your chart

Click OK .

Your chart should update to display the new data:

​

 

[A M I R]

[h=2]Editing Charts

[h=3]Editing the Chart Title
Be sure to select a meaningful title for your chart.

​

 

[A M I R]

[h=2]Editing Charts

[h=5]To change the title of a chart:
Click on the Chart Title.
Use the cursor to select the text

Make any changes that you want to the text.

Click anywhere outside of the title to apply your changes.


​

 

[A M I R]

[h=2]Editing Charts

[h=3]Formatting the Chart Title
In addition to selecting the right title for your for your

chart, you can use the Format Chart Title dialog box to apply several kinds of formatting, including


title color and pattern.

font, size and style.

title alignment.

​

 

[A M I R]

[h=2]Editing Charts

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

Use the different tabs of the Format Chart Title dialog box to apply formatting to your title.

Click OK.

​

 

[A M I R]

[h=2]Editing Charts

[h=3]Formatting the Chart Legend
The chart legend displays very useful information. Be sure to format the legend so that it is as clear as possible.

[h=5]





​

 

[A M I R]

[h=2]Editing Charts

[h=5]To Format the Chart Legend:
If the legend is not showing press the show/hide legend button

on the Chart Toolbar.

Click on the Chart Legend.

Click the Format Button

on the Chart Toolbar (or double click the chart legend).

Use the different tabs of the Format Chart Legend dialog box to apply formatting to the Legend.

Click OK.

The only way to change the actual text of the legend is to make changes to the source data.



​

 

[A M I R]

[h=2]Editing Charts

[h=3]Formatting the Value and Category Axis

You have several options when formatting the Value and Category Axis of

your chart. In addition to changing font, color, and style, you can also adjust the numbers on the Scale of the chart

​

 

[A M I R]

[h=2]Editing Charts

[h=5]To format a Chart Axis:
Select the Axis that you wish to edit.

Click the Format Button

on the Chart Toolbar (or double click the chart axis).

Use the different tabs of the Format Axis dialog box to apply formatting.

Click OK.

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]Editing Charts

[h=3]Changing the Color of a Data Series
You can apply formatting to each data series of a chart. Although you can change

different aspects of each data series, you will probably find that you change the color of bars, columns, pie slices and areas most often.

​

 

[A M I R]

[h=2]Editing Charts



[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 OK

Your chart should display the new colors:

​