How to Create a Grouped Chart with Score Bands and Background Colors in WPS Spreadsheets
Question details
The user wants to create a grouped chart in WPS Spreadsheets that compares student scores by subject and gender while displaying five labeled score bands with separate background colors.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- Visualize student score data with subjects on one axis, Male, Female, and All groups per subject, and a continuous value axis for scores.
- Observed behavior
- The target chart should show grouped categories, a continuous score axis, and five color-coded background bands labeled Excellent, Very Good, Good, Average, and Fail.
Open WPS Spreadsheets and prepare a data table with Subject, Male, Female, All, and student score columns. Also create a helper range with the lower and upper boundary for each of the five score bands so they can be added as chart series.
Build a combination chart with stacked helper series for score bands
Use this method when you need grouped Male/Female/All comparisons and colored score band backgrounds in the same WPS Spreadsheets chart.
The recommended approach is to create a combination chart because WPS Spreadsheets does not have a dedicated Z-axis for this layout. Student score series are plotted as clustered columns or lines, while helper series are plotted as stacked columns or area ranges that form the colored band backgrounds.
In WPS Spreadsheets, arrange Subject, Male, Female, All, and student Score columns, and add helper columns or rows containing the five score band boundaries and labels.
Select the data range, go to Insert > Chart, choose the Combo chart type, and set Male, Female, and All student score series to Clustered Column.
Click Select Data in Chart Tools, add the helper band series, then set each band series to Stacked Column or Area and move them behind the student score series.
Right-click each score band series, choose Format Data Series, and set a distinct fill color and transparency for Excellent, Very Good, Good, Average, and Fail.
Use Chart Tools > Add Data Labels to label the score bands, then adjust the value axis, legend, and colors so the student score series remains visible.
Design grouped score band charts in WPS Spreadsheets
Use WPS Spreadsheets to build a grouped chart with Male, Female, and All categories, overlay student score series, and color-code five score bands by adding stacked helper series or area ranges.
- 1. Prepare the data table: Open WPS Spreadsheets and arrange Subject, Male, Female, All, and Score columns, then add helper columns for the five score band boundaries.
- 2. Insert a combo chart: Select the data, click Insert > Chart, choose Combo, and assign clustered column to the student score series.
- 3. Add score band series: In Chart Tools > Select Data, add the helper score band series and set them to Stacked Column or Area so they appear behind the student scores.
- 4. Apply band colors and labels: Right-click each helper series, choose Format Data Series to set its fill color, then use Add Data Labels to label Excellent, Very Good, Good, Average, and Fail.
- 5. Save as an Excel-compatible file: Click Menu > Save As, choose Excel Workbook (.xlsx), and save the final grouped chart for sharing or further editing.
Frequently Asked Questions
Can I make a true 3D grouped chart with score bands in WPS Spreadsheets?
No. WPS Spreadsheets, like Excel, does not provide a separate Z-axis for this grouped layout. Use a combination chart with stacked column or area helper series to simulate the colored score bands.
How do I add the five score band labels?
Select the helper band series, go to Chart Tools > Add Data Labels, then edit each label to Excellent, Very Good, Good, Average, and Fail. You can also link the labels to worksheet cells so they update automatically.
Which chart type works best for the colored background bands?
Stacked column or area series work best. Place them behind the student score series, then set a distinct fill color and transparency for each band.
Can I save this grouped chart as a Microsoft Excel file?
Yes. In WPS Spreadsheets, click Menu > Save As and choose Excel Workbook (.xlsx). The chart, score band fill colors, and data labels remain compatible with Microsoft Excel.
