How to Create a PivotChart Grouped by Fiscal Quarter in WPS Spreadsheets
Question details
The user needs to build a PivotChart in WPS Spreadsheets that groups data into four fiscal quarters, shows five fiscal-year bars per quarter, and displays the source row count below each bar.
- Product
- WPS Spreadsheets
- Device & OS
- not provided
- Scenario
- Creating a fiscal-year comparative chart from source data with Quarter, Year, and Amount columns.
- Observed behavior
- PivotCharts do not directly support custom spacing between quarter groups or row count labels below each bar, so a companion series or chart is required.
Prepare a source table with at least Quarter, Year, and Amount columns, and make sure each row represents one record. Confirm fiscal quarters are labeled in the desired order, such as Q1, Q2, Q3, Q4, before inserting the PivotChart.
Create a PivotChart Grouped by Fiscal Quarter and Year
Use this main method to build the clustered PivotChart with four quarter groups and five fiscal-year bars per group.
This method creates the main grouped chart from a source table that includes Quarter, Year, and Amount. PivotCharts do not natively support custom spacing between quarter groups or row-count labels under every bar, so use the second solution if you need those labels.
Open WPS Spreadsheets, select a blank worksheet, and enter columns named Quarter, Year, and Amount. Verify that each record is on its own row and that quarter labels use consistent text such as Q1, Q2, Q3, Q4.
Select the source range, go to the Insert tab, click PivotTable, choose New Worksheet, and then insert a PivotChart from the PivotTable. If your version shows a PivotChart option directly, select it instead.
In the PivotChart Fields pane, drag Quarter to the Axis (Categories) area, drag Year to the Legend (Series) area, and drag Amount to the Values area.
Right-click the Quarter labels in the chart or use the field sort options to arrange Q1, Q2, Q3, and Q4 in the required fiscal sequence.
Add Row Count Labels Below Bars with a Companion Series or Chart
Use this when you need the number of source rows for each fiscal-year quarter displayed under the corresponding bar, because a PivotChart cannot add custom labels below every bar directly.
Build a Fiscal Quarter PivotChart in WPS Spreadsheets
Use WPS Spreadsheets to create a PivotChart grouped by fiscal quarter and year from a simple Quarter, Year, and Amount source table. Add a helper RowCount column and companion series to display row counts below bars. WPS keeps the workflow familiar and works with .xlsx files.
- 1. Download and install WPS Office: Go to the official WPS site, download WPS Office, and install WPS Spreadsheets on your device.
- 2. Open your source data: Launch WPS Spreadsheets and open or create the workbook containing Quarter, Year, Amount, and RowCount helper columns.
- 3. Insert and configure the PivotChart: Select the table, go to Insert > PivotTable > PivotChart, then drag Quarter to Axis, Year to Legend, and Amount to Values.
- 4. Add row-count labels: Add RowCount as a second series or companion chart and enable data labels below the bars.
- 5. Save as .xlsx: Go to File > Save As and choose .xlsx format to keep the workbook compatible with Microsoft Excel.
Frequently Asked Questions
Can a WPS PivotChart automatically show the number of rows below each bar?
No, PivotCharts summarize value fields and do not place custom row-count text below every bar automatically. Add a RowCount helper column, drag it to Values, and display it as a companion series with data labels.
How do I arrange the fiscal quarters in the correct order in WPS Spreadsheets?
Use consistent quarter labels like Q1, Q2, Q3, Q4 in the source table, then sort the Quarter axis labels in the PivotChart field settings or use the sort options to arrange them in fiscal order.
Why are my five fiscal-year bars not grouped within each quarter?
Make sure Quarter is in the Axis (Categories) area and Year is in the Legend (Series) area. That places five year bars inside each quarter group. If they appear separately, swap the fields in the PivotChart Fields pane.
Can I adjust the spacing between quarter groups in a PivotChart?
PivotCharts do not offer direct custom spacing between category groups. You can reduce or increase gap width between bars, but distinct spacing between quarter groups usually requires a companion chart or manual layout.
Does WPS Spreadsheets support PivotCharts opened from Excel files?
Yes. WPS Spreadsheets opens and saves .xlsx workbooks, so you can edit PivotCharts created in Excel and save them back in a compatible format.
