Create a Line and Column Combo Chart in Excel for Mac
Question details
The user needs to create a line and column combination chart in Excel for Mac and assign the correct chart type to each data series.

- Product
- Microsoft Excel for Mac
- Device & OS
- Mac / macOS
- Scenario
- Combining two data series in one chart, with one displayed as columns and the other as a line.
- Observed behavior
- Excel may assign the line and column chart types to the wrong data series, requiring manual series ordering and chart type selection.
Make sure your source data includes clear headers so you can identify each series in the chart settings. Decide which series should use columns, which should use a line, and whether their values require different axis scales.
Reorder the data series and assign line and column chart types manually
Use this method when Excel for Mac assigns the wrong chart type to a series in a combination chart.
Select the existing chart, then choose Chart Design > Select Data to open Select Data Source. If you have not created a chart yet, select your data and headers, choose Insert > Column or Bar Chart > Clustered Column, and then open Select Data.
In the series list, select Series A and use the move-down control to place it below Series B. Use your actual series names if they differ, then click OK to apply the order.
Right-click the chart, or Control-click it on your Mac, and choose Change Chart Type. Alternatively, use Chart Design > Change Chart Type. Select Combo to view the chart type settings for each series.
Choose Clustered Column for the series you want displayed as columns and Line for the series you want displayed as a line. If the series use substantially different scales, select Secondary Axis for the appropriate series. Click OK and check the chart against the series names in the legend.

Work With Excel Chart Workbooks in WPS Spreadsheet
WPS Office is a free, lightweight, easy-to-use alternative for everyday spreadsheet and chart work. Its familiar interface and Excel format compatibility help you migrate existing workbooks without starting over. It does not fix Excel for Mac’s chart-series assignment issue; review complex chart formatting when switching applications.

Frequently Asked Questions
How do I switch which series appears as the line?
Select the chart and open Chart Design > Change Chart Type > Combo. Set the intended line series to Line and the other series to Clustered Column, then click OK.
Where can I change the series order in Excel for Mac?
Select the chart and choose Chart Design > Select Data. In Select Data Source, select a series and use the move-up or move-down control to change its position in the series list.
Do I need a secondary axis for a line and column chart?
No. Use one axis when the series share comparable units and scales. If their values or units differ substantially, open Chart Design > Change Chart Type > Combo and select Secondary Axis for the series that needs its own scale.
What if I cannot find the Combo option?
Select the chart first and open Chart Design > Change Chart Type. If Combo is unavailable, check your Excel version through Excel > About Microsoft Excel. Some older versions use different chart controls; try selecting the individual series and changing its chart type, or update Excel through Help > Check for Updates.




