When using WPS Chart, common questions usually fall into 3 areas: insertion, editing, and chart object management; this section covers 4 common questions.
FAQ
How do I insert a chart into the current worksheet?
- Select the data range that includes labels and values.
- Tap Tools and open the Insert tab.
- Tap Chart and choose a type or style.
- The chart is inserted into the current worksheet.
Can I move a chart to another worksheet?
- Tap the chart to select it.
- Choose Cut.
- Switch to the target worksheet.
- Choose Paste to place the chart there.
How do I delete a chart?
- Tap the chart you want to remove.
- Open the chart floating toolbar.
- Tap Delete.
- The chart is removed from the current worksheet.
Why do the legend or proportions look incorrect?
- Check whether the selected data range includes clear headers.
- Make sure the value cells are complete and relevant.
- For pie charts, confirm that the data is suitable for showing proportions.
- If needed, reselect the data range and insert the chart again.
Glossary
| Term | Definition |
|---|---|
| Chart type | The display format used for data, such as line, column, pie, bar, or scatter. |
| Legend | The part of a chart that explains what each color or series represents. |
| Switch rows/columns | A chart setting that reorganizes how data series are displayed by row or by column. |
| Data range | The selected group of cells used to create the chart, usually including labels and values. |