How to insert a line chart in a column chart?
September 14, 2026
11.8K
Views
52
1. Select the cells containing the data that you’d like to use.
2. Click Insert → Chart → Combo.
3. In the Create combination charts area, you can change the chart type of the series that you need to Line, and set up the rest series as Clustered Column. Then click the preview chart, and we can get a desired chart.
For all, easy your work with WPS office suite. Free download WPS Office for PC, Mobile, Windows, Mac, Android, iOS online.
Also Read:
- 1. WPS top 10 Excel gantt chart free templates
- 2. The best gantt chart excel template free download
- 3. The 10 most beautiful Excel daily Gantt chart templates
- 4. Top 10 speedometer chart in Excel template download 2022
- 5. Top 10 yearly gantt chart Excel template download 2022
- 6. How to make the bars wider in a WPS Office Excel chart?
15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.
