How to Add New Data to Excel 2007 Charts

1. Open the Microsoft Excel 2007 application and the worksheet containing the chart that you want to work with.
2. Click on the chart that you want to add new data for to display the Chart Tools. Make sure you also have the new data stored in the same worksheet where the chart is stored.
3. Click on the 'Design' tab and then click on the 'Select Data' option from the 'Data' group.
4. Click on the 'Add' option from the Select Data Source dialog box. The Edit Series dialog box will then appear.
5. Enter the name for the new series of data into the 'Series name' box. Click in the 'Series values' box and then select the group of cells in your worksheet that contain the new data you want to add. The new data will be added to your chart.