Use WPS Pie Chart through 3 how-to topics, including inserting a pie chart, choosing a pie chart subtype, and adjusting chart position and size; 3 items are available without membership and 0 items are membership-related.
How-to Index
| No. | Topic | Membership Requirement |
|---|---|---|
| 1 | 1. Insert a Pie Chart | Free |
| 2 | 2. Choose a Pie Chart Subtype | Free |
| 3 | 3. Adjust Chart Position and Size | Free |
How-to Guide
1. Insert a Pie Chart
Entry: Insert → Chart → Pie
- Select the cell range that contains your data, making sure it includes category labels and numeric values.
- Click the Insert tab.
- Select Pie in the chart options.
- WPS creates the pie chart automatically based on the selected data.
Success Criteria
- Interface result: A new pie chart appears in the worksheet.
- You can continue: You can keep changing the chart style, moving it, or resizing it.
Tips While Using
- Common mistake: If the selected range does not contain valid numeric data, the chart result may not match your expectation.
- Data tip: It is recommended to include both category names and corresponding values.
2. Choose a Pie Chart Subtype
Entry: Insert → Chart → Pie
- Select the data range you want to visualize.
- Click Pie from the Insert tab.
- Choose a specific subtype such as Pie, Pie of Pie, or Bar of Pie.
- Confirm the selection to insert that chart style.
Success Criteria
- Interface result: The inserted chart matches the subtype you selected.
- You can continue: You can compare how different subtypes present the same data.
Tips While Using
- Common mistake: Before choosing a subtype, confirm that the data is suitable for part-to-whole presentation.
- Usage tip: If there are many categories, a split subtype can help separate smaller items more clearly.
3. Adjust Chart Position and Size
Entry: Select the chart after it is created
- Click the pie chart in the worksheet.
- Drag the chart to a suitable position.
- Drag the sizing handles on the border to resize the chart.
- Review the layout with the surrounding worksheet content and fine-tune it as needed.
Success Criteria
- Interface result: The chart position and size change on the worksheet.
- You can continue: The chart remains selectable and editable.
- No side effect: The original spreadsheet data is not overwritten when the chart is moved.
Tips While Using
- Common mistake: While dragging, avoid selecting worksheet cells by mistake.
- Layout tip: Keep the chart from covering important data areas.