Update a Chart

If you create a chart for your presentation and then the data used in the chart changes, you can update the data so that the chart is accurate.

To change the data in an existing chart:

1. Select the chart that you want to change.
2. Under Chart Tools, on the Design tab, in the Data group, click Show Data.
   Microsoft Office Excel opens in a split window and displays the worksheet that you want to edit.
   
3. To edit the contents of a title or data in a cell, in the Excel worksheet, click the cell that contains the title or the data that you want to change, and then type the new information.
4. The chart will reflect the change
5. In Excel, on the Microsoft Office Button, click Close.

To change the format of the chart:

1. Right-click in the area of the chart.
2. A menu will appear.
3. Select the task you want to accomplish. In this case, I’ve selected Format Data Series.
   
4. The Format Data Series dialog box will appear.
   
5. Select your changes.
6. The chart below reflects changes in fill color, the addition of gradient fill, and the addition of texture fill: