WPS Features
Resources
Free AI Tools
Docs Center

How to Use WPS Chart on Windows

Last updated:July 16, 2026

This how-to guide includes 4 chart topics in WPS on Windows, covering chart insertion, quick chart generation, chart editing, and one membership-related style task; 3 topics are free and 1 is membership-related.

How-to Index

No.TopicMembership Requirement
11. Insert a ChartFree
22. Generate a Chart QuicklyFree
33. Edit a ChartFree
44. Apply Some Membership-Related Chart StylesMembership-related

How-to Guide

1. Insert a Chart

Entry point: Insert → Chart

  1. Prepare the worksheet data you want to visualize.
  2. Click Insert and then click Chart.
  3. In the dialog box, choose a chart category on the left and a specific subtype on the right.
  4. Confirm the selection to insert the chart into the current worksheet.

Success Criteria

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

Tips While Using

  • Common mistake: If the data range is not organized first, the generated chart may need extra adjustment.
  • Environment note: A header row helps the app identify series names more clearly.

2. Generate a Chart Quickly

Entry point: Keyboard shortcut F11 or Alt+F1

  1. Select the full data range, including headers and values.
  2. Press F11 to generate a default column chart in a new chart sheet.
  3. Or press Alt+F1 to insert a default column chart in the current worksheet.
  4. After the chart appears, continue editing its type, color, or layout with chart tools.

Success Criteria

  • Interface result: A default chart is generated automatically.
  • What you can do next: You can continue editing chart type, elements, and styles.

Tips While Using

  • Common mistake: If the selected range is incomplete, the chart may not show all expected data.
  • Environment note: Different shortcuts place the chart in different locations, so confirm the target worksheet first.

3. Edit a Chart

Entry point: Select chart → Chart Tools

  1. Click the chart so it becomes selected.
  2. Open the chart-related tools on the ribbon.
  3. Use Change Type to switch to another chart type.
  4. Use Add Element to add a title, data labels, legend, trendline, or error bars.
  5. Right-click the chart or a chart element and open the formatting options to adjust color, font, border, and related styles.

Success Criteria

  • Interface result: Chart tools are visible and the chart style or elements change as expected.
  • What you can do next: You can continue switching rows and columns, selecting data, or resetting styles.

Tips While Using

  • Common mistake: If the chart is not selected, chart tools will not appear.
  • Environment note: Some formatting changes require you to select a specific chart element first.

Entry point: Select chart → style-related options in Chart Tools

  1. Insert a chart first or select an existing chart.
  2. Open the style, format, or design-related options in chart tools.
  3. Browse the available styles and choose the appearance you want.
  4. If a membership prompt appears, sign in with an account that has an active subscription to continue using that style.
  • Interface result: The chart uses a new style, or the app shows that the selected style requires membership.
  • What you can do next: You can save the worksheet or continue exporting the chart result.
  • Common mistake: If you are not signed in, it may be harder to confirm the current account benefits.
  • Membership note: Some styles require WPS Premium.
  • Environment note: Membership availability depends on the current account subscription status.