Excel XP

Introduction

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

• Change Chart Data
• Change the Chart Title
• Change the Data Series Names or Legend Names
• Change the Chart Type

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.

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.

Changing Chart Data (continued)

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.

Changing the Chart Title

The Chart Title can be changed at any time to a name that's meaningful to you.

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.

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.

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.

Changing the Chart Type

There are 14 different types of charts in Excel XP, 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.

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.

Challenge

• Type the following information on the worksheet:
  In cell A2, type Bill
  In cell A3, type Bob
  In cell A4, type Mary
  In cell B1, type Phones
  In cell B2, type 7630
  In cell B3, type 2943
  In cell B4, type 2301
  In cell C1, type Cables
  In cell C2, type 9873
  In cell C3, type 3745
  In cell C4, type 2019
  In cell D1, type Internet
  In cell D2, type 8374
  In cell D3, type 2049
  In cell D4, type 4038
• Create an embedded Bar Chart that plots Bill, Bob and Mary on the Y- axis. The Legend will comprise Phones, Cables and Internet.
• Change any of the numbers in the Data Source (cells B2, B3, B4, C2, C3, C4, D2, D3 or D4) and notice how the chart changes.
• Change any Data Series Name (Bill, Bob or Mary) or Legend Value (Phones, Cable or Internet) and notice how the chart changes.
• Change the Chart Type from a Bar Chart to a Line Chart.