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; use the index below to jump to each task.
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: 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 chart options and select Stock Chart.
- Let WPS generate the chart from the current data range.
Success Criteria
- Interface result: A new stock price chart appears in the worksheet.
- What you can do next: You can continue by choosing a subtype or adjusting the chart position and size.
Tips While Using
- Common mistake: If you do not select a valid data range first, the chart may not be created correctly.
- Environment note: The data range should include headers and numeric values so the chart structure can be recognized correctly.
2. Choose a Stock Chart Subtype
Entry: Insert → Chart → Stock Chart
- Select the data range you want to use for the chart.
- Click the Insert tab and open the Stock Chart options.
- Choose a specific subtype from the list, such as high-low-close, close, or volume-related layouts.
- Confirm the selection to generate the matching chart style.
Success Criteria
- Interface result: The chart style matches the subtype you selected.
- What you can do next: You can move the chart, resize it, or use it in analysis and reporting.
Tips While Using
- Common mistake: If the subtype does not match the data structure, the chart result may not look as expected.
- Environment note: Choose the subtype according to the actual columns in your data.
3. Adjust Chart Position and Size
Entry: Select the generated stock price chart
- Click the generated stock price chart in the worksheet.
- Drag the chart to a suitable position.
- Drag the chart border or sizing handles to adjust its display size.
- Place the chart where it is easy to read and present.
Success Criteria
- Interface result: The chart position or size changes in the worksheet.
- What you can do next: The chart can be used together with worksheet content for presentation, reporting, or further editing.
Tips While Using
- Common mistake: If the chart is not selected first, dragging may select cells instead of moving the chart object.