Use WPS Stock Price Chart through 3 how-to topics, including inserting the chart, choosing a stock chart subtype, and adjusting chart position and size; 3 items are available without membership and 0 are membership-related.
How-to Index
| No. | Topic | Membership Requirement |
|---|---|---|
| 1 | 1. Insert a Stock Price Chart | Free |
| 2 | 2. Choose a Stock Chart Subtype | Free |
| 3 | 3. Adjust Chart Position and Size | Free |
How-to Guide
1. Insert a Stock Price Chart
Entry point: Insert → Chart → Stock Chart
- Select the cell range that contains your data, and make sure it includes category headers and numeric values.
- Click the Insert tab.
- Open the Stock Chart option in the chart area.
Success Criteria
- Interface result: You enter the stock chart insertion flow.
- Next action available: You can continue by choosing a specific subtype and generating the chart.
Tips While Using
- Common mistake: If the selected data range is incomplete, the chart result may not match your expectation.
- Environment note: It is helpful to organize headers and value columns before inserting the chart.
2. Choose a Stock Chart Subtype
Entry point: Insert → Chart → Stock Chart
- After opening the stock chart option, review the available subtypes.
- Choose a subtype based on your display needs, such as high, close, or volume-related layouts.
- Confirm the selection to generate the chart.
Success Criteria
- Interface result: A stock chart appears in the worksheet.
- Next action available: You can continue moving the chart or adjusting its size.
Tips While Using
- Common mistake: If the subtype does not match the data structure, the chart may not display clearly.
- Environment note: Stock charts work better with continuous time-series data.
3. Adjust Chart Position and Size
Entry point: The generated stock chart object
- Click the stock chart in the worksheet.
- Drag the chart to the position you want.
- Drag the chart handles on the border to resize it.
- Continue refining the layout based on your page or report design.
Success Criteria
- Interface result: The chart position or size changes.
- Next action available: You can continue editing worksheet data or arranging the report layout.
- No side effect: The original data range remains in the worksheet.
Tips While Using
- Common mistake: It is easy to select cells instead of the chart while dragging, so confirm that the chart object is selected first.
- Environment note: If the chart is too small, price movement becomes harder to read.