Feature Summary
WPS Sheets supports inserting stock charts (candlestick charts) in collaboration mode, using a specialized graph to display the fluctuation of opening, closing, highest, and lowest prices over a period of time, suitable for visual analysis of financial data and price trends.
Feature Description
| Feature Dimension | Description |
|---|---|
| Membership Restriction | No membership restriction |
| Version Restriction | No version restriction |
Operation Steps
Insert Stock Chart
Feature Entry
"Insert" tab → "Chart" → "Stock Chart"
- Select the cell range containing the data (ensure it includes category headers and values)
- Click the "Insert" tab, select "Stock Chart"
- Then choose a specific subtype (High, Close, Volume, and so on.)
- The stock chart will be automatically generated; you can drag to adjust its position and size
FAQ
Q1: What data format is required for a stock chart?
- Solution: A stock chart typically requires four columns of data (in order): Date/Time, Open, High, Low, Close. The High must be ≥ Open and Close, and the Low must be ≤ Open and Close.
Q2: Can stock charts only display stock data?
- Solution: No. Stock charts are suitable for any data scenario containing four price values—Open, High, Low, Close—such as commodity price fluctuations, exchange rate changes, temperature ranges, and other interval-type data displays.
Notes
- Stock charts have strict requirements for data column order; incorrect column order will cause abnormal graph display
- Stock charts are suitable for displaying price fluctuations in continuous time series and are not suitable for comparing discrete categories of data