How to Use WPS Stock Price Chart on Windows

Use Stock Price Chart with 3 how-to topics: insert a stock price chart, choose a stock price chart subtype, and check the data format; all 3 topics are available without membership.

How-to Index

How-to Guide

1. Insert a Stock Price Chart

Entry path: Insert → Chart → Stock Price Chart

1. Select the cell range that contains your data, including category labels and numeric values.
2. Click the Insert tab.
3. Open Stock Price Chart in the chart options.
4. After the chart is created, drag it to the right position and resize it as needed.

Success Criteria

• Interface result: A new stock price chart appears in the worksheet.
• What you can do next: You can continue adjusting the chart position, size, or style.

Tips While Using

• The selected range should include labels and values so the chart can be recognized correctly.
• Stock price charts work better with continuous time-series data.

2. Choose a Stock Price Chart Subtype

Entry path: Insert → Chart → Stock Price Chart

1. Select the target data range.
2. Click Stock Price Chart on the Insert tab.
3. Choose a subtype such as high-low-close, close-only related layouts, or volume-related layouts based on the available options in the interface.
4. Review the generated chart and confirm that the selected subtype matches your data structure.

Success Criteria

• Interface result: The inserted chart matches the subtype you selected.
• What you can do next: You can continue changing the layout or switch to another subtype.

Tips While Using

• Different subtypes may require different data columns.
• If the chart looks incorrect, check the column order and insert it again.

3. Check the Data Format for a Stock Price Chart

Entry path: Organize the worksheet data before insertion

1. Confirm that the table includes a category field such as date or time.
2. Arrange the numeric columns for open, high, low, close, and other values required by the selected stock chart subtype.
3. Check that the high value is not lower than the open or close value, and that the low value is not higher than the open or close value.
4. Select the organized range again and insert the stock price chart.

Success Criteria

• Interface result: The chart is created normally and the price range looks reasonable.
• What you can do next: You can switch subtypes or continue refining the chart display.

Tips While Using

• Incorrect column order can cause abnormal chart output.
• Non-continuous or purely discrete categories are usually not suitable for this chart type.