How to Use WPS Insert Chart on Windows

This guide includes 3 how-to topics for WPS Insert Chart on Windows, covering insertion from the Home tab, insertion from the Insert tab, and chart adjustment; all 3 topics are available without membership.

How-to Index

How-to Guide

1. Insert a chart from the Home tab

Entry: Home tab → chart drop-down button at the upper-right side of the ribbon

1. Select the data range you want to turn into a chart. It is helpful to include the header row and data columns.
2. Click the Home tab.
3. Find the chart drop-down button on the right side of the ribbon and open it.
4. Choose a chart type such as column, line, pie, bar, area, scatter, stock, radar, combo, or sparkline.
5. Select a specific subtype, and the chart is inserted into the current worksheet automatically.

Success Criteria

• Interface result: A new chart object appears in the current worksheet.
• What you can do next: You can drag the chart, resize it, or continue editing it.

Tips While Using

• Common mistake: If the header row or full data columns are not selected, labels and legends may not display correctly.
• Environment note: Some chart types, such as stock charts, work better with data arranged in a matching structure.

2. Insert a chart from the Insert tab

Entry: Insert tab → chart buttons on the right side of the toolbar

1. Select the data range you want to chart.
2. Click the Insert tab.
3. Find chart entries such as column chart or line chart in the ribbon.
4. Select the chart type you want, and the chart is inserted into the current worksheet automatically.

Success Criteria

• Interface result: The selected chart type appears in the worksheet.
• What you can do next: You can continue changing the chart position, size, and style.

Tips While Using

• Common mistake: If you do not select a data range first, the inserted chart may not reflect the intended data correctly.
• Environment note: Different chart types fit different data structures.

3. Adjust an inserted chart

Entry: Click the chart object → chart editing options

1. After inserting the chart, drag its border to move it.
2. Drag the corner handles to resize it.
3. Click the chart and use the chart editing options above to change the title, colors, and style.

Success Criteria

• Interface result: The chart position, size, or style updates as needed.
• What you can do next: You can save the worksheet or continue refining the chart.

Tips While Using

• Common mistake: If the chart is not selected first, the related editing options may not appear.
• Environment note: The available adjustment details can vary by chart type.