Chart & Visualization Issues

Create a Line and Column Combo Chart in Excel for Mac

Steve KSteve K Nov 13, 2026 869 views

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.

Create a Line and Column Combo Chart in Excel for Mac
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the chart’s data settings

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.

2
Adjust the series order

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.

3
Choose a combination chart

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.

4
Set each series to the correct chart type

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.

Reorder the data series and assign line and column chart types manually
Series order does not replace chart type selection: Reordering the series can help correct the initial arrangement, but explicitly assigning each series its chart type is the key step. A secondary axis is optional, not a requirement for a combo chart.
Free Microsoft Office alternative

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.

Open and edit Microsoft Excel .xlsx and .xls workbook formats.Use spreadsheet chart tools to visualize and compare data series.Work in a familiar spreadsheet interface for easier migration from Excel.Use a lightweight, free Office suite for everyday document and spreadsheet tasks.
microsoft office alternative - wps office

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.