You can change the data range used as the source data for you chart.The chart will be updated accordingly based on the new data range.
To change a range, perform the following actions:
1.Select the chart.
2.Move the corner handle to change the chart range while holding the left mouse button pressed.
3.Release the left mouse button to fix the new range.
Additionally, you can change the data range in the Chart Settings window. To do this, follow these steps:
1.Select the chart you want to edit.
2.On the Toolbar, select the Chart section and select the (Settings) button.
3.On the Chart Settings window, press the button in the Range box. This will activate the range selection mode. The pointer shape will change.
4.Select a cell range on the current sheet or on another sheet of a spreadsheet. Once the left mouse button is released, the range will be confirmed and displayed in the Range box.
5.Click OK to apply the range. This will automatically recalculate the chart data for the new cell range.