Add data to a chart

1. Select the cells that contain the data you want to add to the chart. If you want the column or row label for the new data to appear in the chart, include the cell that contains the label in the selection.
2. Click Copy .
3. Click the chart.
4. Do one of the following:
   • To have Microsoft Excel automatically paste the data in the chart, click Paste .

   • To specify how you want to plot the data in the chart, click Paste Special on the Edit menu, and then select the options you want.

The embedded chart must be created from adjacent selections and be on the same worksheet as the data used to create it.

1. Type the data and labels you want to add on the worksheet in the cells next to the existing data.
2. Select the chart area by clicking the blank area between the border of the chart and the plot area.
3. Do one of the following:
   • To add new categories and data series to the chart, on the worksheet, drag the blue sizing handle to include the new data and labels in the rectangle.

   • To add new data series only, on the worksheet, drag the green sizing handle to include the new data and labels in the rectangle.

   • To add new categories and data points, on the worksheet, drag the purple sizing handle to include the new data and labels in the rectangle.

1. Select the cells that contain the data you want to add to the chart. The cells must be next to each other on the worksheet.

   If you want the column or row label for the new data to appear in the chart, include the cell that contains the label in the selection.

2. Point to the border of the selection.

   

3. Drag the selection to the embedded chart you want to update.

   If Microsoft Excel needs more information to plot the data, the Paste Special dialog box appears. Select the options you want.

Note  If you cannot drag the selection, make sure that the Allow cell drag and drop check box is selected. To check this setting, click Options on the Tools menu, and then click the Edit tab.