How to Use WPS Insert Chart on macOS

Use Insert Chart with 3 how-to topics: insert from Home, insert from Insert, and adjust the chart; choose a topic from the index and follow the steps.

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

1. Select the data range you want to turn into a chart. It helps to include both headers 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 the chart type you need, 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.

Success Criteria

• Interface result: A new chart object appears in the current worksheet.
• What you can do next: You can select the chart and continue changing its position, size, or style.

Tips While Using

• Common mistake: If headers and data columns are not fully selected, legend labels or axis labels may be incomplete.
• Environment note: Some chart types, such as stock charts, usually need a more specific data structure.

2. Insert a chart from the Insert tab

Entry: Insert tab → chart button 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. Choose the chart type you want, and the chart is inserted into the current worksheet.

Success Criteria

• Interface result: The selected data is displayed as a chart in the worksheet.
• What you can do next: You can continue changing the chart type or editing chart content.

Tips While Using

• Common mistake: If the selected range contains many blank cells, the chart may show gaps or missing items.
• Environment note: It helps to clean up the data before inserting the chart.

3. Adjust the chart

Entry: Select an inserted chart → drag it directly or use chart editing options above

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

Success Criteria

• Interface result: The chart position, size, or style changes.
• What you can do next: You can continue editing the title, colors, legend, and other display items.

Tips While Using

• Common mistake: If the chart is not selected first, dragging may only select worksheet cells.
• Environment note: Available style options can vary by chart type.