Procedure: Edit Chart Data
To edit chart data:
1. Click the chart to select it.
2. On the ribbon, select the Design contextual tab.
3. In the Data group, click Edit Data.
4. In the Excel worksheet, make the relevant changes to the data.
5. Close the Excel worksheet.
6. Notice that the updated values are reflected in the chart.
………………………Thanks everyone