How to Create a Quarterly XY Scatter Chart for Volume and Unit Price in WPS Office Spreadsheet
Question details
The user needs to build a quarterly XY scatter chart in WPS Office Spreadsheet that plots Volume on the horizontal axis and Unit Price on the vertical axis, with each quarter visually distinguished.
- Product
- WPS Office Spreadsheet
- Device & OS
- not provided
- Scenario
- Analyzing how quarterly volume and unit price relate, using numeric values and quarter labels.
- Observed behavior
- The user wants the final chart to show Volume on the X-axis, Unit Price on the Y-axis, and a clear visual distinction for each quarter.
Prepare a worksheet with three columns: Quarter, Volume, and Unit Price. Confirm that Volume and Unit Price are numeric values and that every row has a quarter label such as Q1, Q2, Q3, or Q4.
Create an XY Scatter Chart with a Separate Series for Each Quarter
Use this method when you want distinct colors, legend entries, and clean series control for each quarter.
An XY Scatter chart requires numeric X and Y values. In WPS Office Spreadsheet, Volume can be set as X and Unit Price as Y; splitting the data into one series per quarter makes quarterly differences easier to read.
Open WPS Office Spreadsheet and set up three columns: Quarter, Volume, and Unit Price. Enter numeric values in the Volume and Unit Price columns, and label each row with the correct quarter.
Select the Volume and Unit Price columns, including headers if available.
Go to the Insert tab on the ribbon and click Chart. In the Insert Chart dialog, choose XY (Scatter), pick a scatter style, and click OK.
Right-click the chart and choose Select Data, or use the Chart Tools tab to open the Select Data dialog.
In the Select Data dialog, click Add. For each series, set the Series name to the quarter label, X values to that quarter's Volume cells, and Y values to that quarter's Unit Price cells. Repeat until all quarters are added.
Use Chart Tools to add a chart title, axis titles for Volume and Unit Price, and a legend. Optionally customize point colors or add data labels by quarter.
Label One Combined XY Scatter Series by Quarter
Use this method when you prefer to keep all points in a single series and label them by quarter instead of creating separate series.
Create a Quarterly XY Scatter Chart in WPS Office Spreadsheet
Use WPS Office Spreadsheet to insert an XY Scatter chart, set Volume as the X values and Unit Price as the Y values, and add each quarter as a separate series or label.
- 1. Open the workbook in WPS Office Spreadsheet: Launch WPS Office Spreadsheet and open the workbook containing Quarter, Volume, and Unit Price columns, or create a new workbook and enter your data.
- 2. Insert an XY Scatter chart: Select the Volume and Unit Price data, click the Insert tab, click Chart, choose XY (Scatter), and click OK.
- 3. Define quarterly series: Right-click the chart and choose Select Data. Add a series for each quarter, with the series name set to the quarter label, X values set to that quarter's Volume cells, and Y values set to that quarter's Unit Price cells.
- 4. Format and identify quarters: From Chart Tools, add a chart title, axis titles, and legend. Apply different point colors or data labels so each quarter is easy to distinguish.
- 5. Save or share in Excel format: Click File > Save As and choose WPS Office or Excel Workbook .xlsx to save the chart and data for sharing.
Frequently Asked Questions
What data arrangement does an XY Scatter chart require in WPS Office Spreadsheet?
It requires numeric X and Y values. For a quarterly view, use three columns: Quarter, Volume, and Unit Price. Volume is the X value and Unit Price is the Y value.
Can I create separate XY Scatter series for each quarter?
Yes. Right-click the chart and choose Select Data, then click Add. For each series, set the series name to the quarter label, X values to that quarter's Volume cells, and Y values to that quarter's Unit Price cells.
How do I make quarter labels appear on data points?
Right-click a data point and choose Add Data Labels or Format Data Labels. If your WPS version supports cell-range labels, select the Quarter column; otherwise type the quarter labels manually.
Why does my XY Scatter chart not show the correct X axis?
Make sure the Volume column is numeric and is assigned as the X values. If WPS treats the values as text or categories, the chart may not plot them as expected.
Can I save the quarterly XY Scatter chart workbook in Microsoft Excel format?
Yes. In WPS Office Spreadsheet, click File > Save As and choose Excel Workbook .xlsx so the file remains compatible with Microsoft Excel.
