Chart Toolbar, Selecting, Changing, Adding, Removing , Moving , Resizing , Deleting Data

First / Using the Chart Toolbar

 »  Displaying the Chart Toolbar/The Chart toolbar provides quick access to commonly  used actions. Each action is represented by an icon. When you put your mouse pointer over an icon, it is highlighted in blue and a descriptive tool tip appears.

From the main menu, choose View   →  Toolbars  → Chart.

 »Using the Chart Toolbar 

1- The Chart toolbar provides quick access to commonly used actions. Each action is represented by an icon. When you put your mouse pointer over an icon, it is highlighted in blue and a descriptive tool tip appears.

2- Locate the icon for the action you want to use and click on the icon.

3- The following are icons on the Chart Toolbar:

»Selecting a Chart

1- Place your mouse over a blank area of chart you want to select, and check to make sure

that the screen tip appears as Chart Area.

 2-Click on the chart. Black square handles will appear around the chart:

»Selecting Chart Objects

1- From the Chart toolbar, click on the Chart Object down arrow, and select the chart object you want:

 

Second / Working with Charts

After creating a chart using the Chart Wizard, you can modify your chart by:

1.                   Changing the Chart Type

2.                   Adding data to the Chart

3.                   Removing data from the Chart

4.                   Moving the Chart to a new location

5.                   Resizing the Chart

6.                   Deleting the Chart

  

»Changing the Chart Type

1- Select the chart you want to affect.

2- From the Chart toolbar, click the Chart Type down arrow, and select the new chart type you want:

 

The following are examples of common chart types:

►Column Charts:

A column chart shows data changes over a period of time or illustrates comparisons among items. Categories are organized horizontally, values vertically.

  

   

►Bar Charts:

A bar chart illustrates comparisons among individual items. Categories are organized vertically, values orizontally.

  

►Line Charts:

A line chart shows trends in data at equal intervals.

 

►Pie Charts:

 A pie chart shows the proportional size of items that make up a data series to the sum of the items. It always shows only one data series and is useful when you want to emphasize a significant element.

   

»Adding Data to a Chart

1-  Select the data you want to add.

2-  To add data from the same Worksheet as the chart:

Drag and drop the data onto the chart.

3- To add data from a different Worksheet as the chart:

-  From the Standard toolbar, click on the Copy icon to copy the data.

-  Switch to the Worksheet containing the chart, and click on the chart to select it.

-  From the Standard toolbar, click on the Paste icon to insert the data into the chart.

  

»Removing Data from a Chart

1- Select the data series (represented in the chart by the same color) you want to delete.

2- Press the Delete key.

Note: The chart data is removed from the chart, but remains in the Worksheet.

»Moving a Chart

1- Select the chart you want to move.

2- Drag and drop the chart to the new location.

»Resizing a Chart

1- Select the chart you want to resize.

2- Place your mouse pointer over one of the square, resize handles, and drag the resize handle to the desired size.

 

»Deleting a Chart

1- Select the chart you want to delete.

2- Press the Delete key.