Changing data source ranges

Use the Chart Settings window to change a chart's data source ranges without having to redo the chart in the sheet.

Procedure

  1. Select the chart for which you want to change data source values.
  2. Right-click the chart and select Edit Chart. The Chart Settings window opens.
  3. Click Data.
    set data ranges
  4. Choose the series you want to edit by clicking the drop-down menu in the Series.
  5. Name the series in the Series Name field.
  6. In the Series Values field, enter the data range that you want.
    Note: You can also input one string or one series of data in the Series Values input field.
  7. Optional: In the Category field, enter the category range.
  8. Click OK.