Change chart data source

If necessary, you can change the range of data that is used to create the chart. In this case, the chart will be rearranged according to the new range borders.

To change the range, follow these steps:

1.Select the chart.

2.While holding down the left mouse button, move the corner handle of the data range that was used to create the chart.

3.Release the left mouse button to define the borders of the new range.

You can also change the data range in the chart settings pane. To do this, follow these steps:

1.Open the chart settings pane on the Sidebar.

2.On the Settings tab, in the Range box, click . This will activate the range selection mode and the button will change its appearance.

3.Use the mouse to select the required cell range on the current or any other sheet of the document. As soon as you release the left mouse button, the specified range will be defined and displayed in the Range box.

4.Click OK to apply the set range. This will automatically recalculate the chart data for the newly defined cell range.