WPS Features
Resources
Free AI Tools
Docs Center

How to Select and Edit Data in WPS on Windows

Last updated:July 13, 2026

Use Select and Edit Data with 3 how-to topics, including selecting a data source, editing chart data, and editing data from the right-click menu; 3 items are available without membership and 0 items are membership-related.

How-to Index

No.TopicMembership Requirement
11. Select a Data SourceFree
22. Edit Chart DataFree
33. Edit Data from the Right-Click MenuFree

How-to Guide

1. Select a Data Source

Entry: Chart Tools → Select Data

  1. Click the chart to select it.
  2. Click the Chart Tools tab on the top menu bar.
  3. Click Select Data.
  4. In the dialog box, choose the data range you want to use.
  5. Click OK to finish.

Success Criteria

  • Interface result: The Select Data settings window opens or the selection is applied.
  • What you can do next: The chart displays content based on the new data range.
  • No side effect: The original slide layout remains unchanged.

Tips While Using

  • Common mistake: If the chart is not selected first, chart-related tools may not appear.
  • Environment note: The chart must remain editable.

2. Edit Chart Data

Entry: Chart Tools → Edit Data

  1. Click the chart to select it.
  2. Click Edit Data.
  3. Modify the content in the data table that opens.
  4. Check whether the chart updates after the changes.

Success Criteria

  • Interface result: The chart data table opens.
  • What you can do next: After cell values are changed, the chart reflects the updated data.
  • No side effect: You do not need to insert the chart again.

Tips While Using

  • Common mistake: After editing values, users may forget to review series names or category labels.
  • Environment note: It is helpful to confirm the original data structure before making changes.

3. Edit Data from the Right-Click Menu

Entry: Chart → Right-click → Edit Data

  1. Right-click the chart.
  2. Select Edit Data from the shortcut menu.
  3. Modify the data in the table.
  4. Close the table and check whether the chart updates automatically.

Success Criteria

  • Interface result: The shortcut menu shows the Edit Data entry and opens the data table normally.
  • What you can do next: After the table is closed, the chart shows the updated result.
  • No side effect: You do not need to switch to another editing path.

Tips While Using

  • Common mistake: If you right-click outside the chart object, the chart shortcut menu will not appear.
  • Environment note: If the chart object is locked or not editable, related entries may be unavailable.