How to Create a Daily Line and Annual Column Combination Chart in WPS Office Spreadsheets
Question details
User needs to combine daily time-series data as a line and annual summary values as columns in one date-based chart.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The user has daily records and annual totals in a spreadsheet and wants both series displayed together for comparison.
- Observed behavior
- A single chart should show daily values as a continuous line and annual values as columns, with compatible date ranges and axes.
Prepare a shared data table with one column containing real Date values, one column for daily line values, and one column for annual summary values aligned with the corresponding years.
Create a combination chart from a shared date-based table
Use this when you need daily series as a line and annual totals as columns in one chart.
WPS Office Spreadsheets supports combination charts, so you can assign each data series its own chart type and axis. Keep dates in a true Date format so the horizontal axis displays time correctly.
Select the range containing the Date, Daily Value, and Annual Total columns, including headers.
Go to the Insert tab, click Chart, and choose Combo from the chart type list.
In the Chart Type settings, set Daily Value to Line and Annual Total to Column.
Open Axis Options for the horizontal axis and set Axis Type to Date so daily and annual points align by date.
Separate daily and annual scales with a secondary axis
Use this when annual columns are much larger or smaller than daily values and are hard to read on the same scale.
Create a Daily Line and Annual Column Combo Chart in WPS Office Spreadsheets
WPS Office Spreadsheets can directly build a date-based combination chart with daily values as a line and annual totals as columns. Use the Insert > Chart combo tools and date axis options, then save as a standard .xlsx file that remains compatible with Microsoft Excel.
- 1. Download and install WPS Office: Download WPS Office from the official website, install it, and open WPS Spreadsheets.
- 2. Open your data workbook: Open the workbook that contains your daily dates, daily values, and annual totals.
- 3. Insert a combo chart: Select the date and value columns, click Insert > Chart, and choose Combo.
- 4. Assign series types and axes: Set the daily series to Line and the annual series to Column; enable a secondary axis for the annual series if needed.
- 5. Save as an Excel-compatible workbook: Save the file as .xlsx so the combination chart remains editable in Microsoft Excel and WPS Office.
Frequently Asked Questions
Why does my annual column appear as a thin line in the chart?
Select the chart, right-click the annual series, choose Change Series Chart Type, and set it to Column. In WPS Office, you can also use Chart Tools > Series Options to assign the correct chart type.
How do I put daily lines and annual columns on different axes?
Select the annual series, open Format Data Series, and choose Secondary Axis. This lets the annual columns use a separate scale while the daily line remains on the primary axis.
What date format should the horizontal axis use?
Use real date cells formatted as Date, then in Chart Tools > Axis Options set the horizontal axis type to Date axis instead of Text axis.
Can I reopen this combo chart in Microsoft Excel?
Yes. Save the workbook as .xlsx in WPS Office, and the series types and date axis settings are preserved when the file is opened in Microsoft Excel.
