Use Chart with 4 how-to topics, including inserting a chart, choosing a chart type, editing a chart, and using membership styles or managing chart objects.
How-to Index
| No. | Topic | Membership Requirement |
|---|---|---|
| 1 | 1. Insert a Chart | Free |
| 2 | 2. Choose a Chart Type | Free |
| 3 | 3. Edit a Chart | Free |
| 4 | 4. Use Membership Styles or Manage a Chart | WPS Premium |
How-to Guide
1. Insert a Chart
Feature entry: Tools at the bottom → Insert → Chart
- Select the cell range that contains your data, including labels and values.
- Tap Tools at the bottom.
- Select the Insert tab.
- Tap Chart.
- The chart is inserted into the current worksheet.
Success Criteria
- Interface result: A new chart object appears in the current worksheet.
- What you can do next: You can continue by choosing a chart type or editing the chart.
Tips While Using
- Common mistake: If labels and values are not selected completely, the legend or category axis may be inaccurate.
- Environment note: Open a spreadsheet first and select a valid data range.
2. Choose a Chart Type
Feature entry: The chart type selection screen after you start inserting a chart
- Review the available chart types on the selection screen.
- Choose a line, column, pie, bar, or scatter chart based on your data.
- Continue by selecting a specific chart style.
- Confirm to insert the chart into the worksheet.
Success Criteria
- Interface result: The chart appears in the worksheet in the selected type.
- What you can do next: You can tap the chart and continue adjusting style or data source.
Tips While Using
- Common mistake: Pie charts fit proportion data better, while line charts fit trend data better.
- Membership note: Some chart styles require membership.
3. Edit a Chart
Feature entry: Tap the chart → Tools at the bottom
- Tap the inserted chart.
- Tap Tools at the bottom.
- Choose Chart Style, Select Data, or Quick Layout as needed.
- Tap another area of the worksheet to exit editing mode after the changes are complete.
Success Criteria
- Interface result: The chart style, data source, or layout changes accordingly.
- What you can do next: You can save the spreadsheet or continue editing.
Tips While Using
- Common mistake: If the chart is not selected first, the bottom toolbar will not switch to chart editing tools.
4. Use Membership Styles or Manage a Chart
Feature entry: Style options or the floating toolbar after selecting a chart
- Tap the chart and review the available styles.
- If you want to use a restricted style, follow the on-screen prompt to subscribe before applying it.
- To move a chart, tap the chart, choose Cut, switch to the target worksheet, and choose Paste.
- To delete a chart, tap the chart and choose Delete on the floating toolbar.
Success Criteria
- Interface result: The style is applied, or the chart is moved, pasted, or deleted.
- What you can do next: You can continue editing the chart in the target worksheet or insert a new chart.
Tips While Using
- Membership note: Some chart styles require WPS Premium.
- Common mistake: Before deleting, confirm that the selected object is the chart you want to remove.