How to Build a Combo Chart in PowerPoint With Bars and Lines

A combo chart combines two chart types, typically bars and lines, in a single visual. This lets you compare related data sets that use different scales, such as monthly revenue in dollars and profit margin as a percentage. You may need a combo chart to show a trend line overlaid on column data without creating two separate charts. This article walks you through inserting a combo chart in PowerPoint, setting series to bars or lines, and assigning a secondary axis.

What a Combo Chart Does and What You Need Before Starting

A combo chart displays two or more data series using different chart types in the same plot area. The most common combination is columns for one data set and a line for another. This layout works well when the two data sets have different units or magnitudes. For example, you might show total sales as bars on the left axis and customer satisfaction score as a line on the right axis.

Before you build a combo chart, confirm that your data is organized in a table with clear row and column headers. PowerPoint reads data from an embedded Excel sheet. You need at least two data series to create a combo chart. One series will become bars, and the other will become the line. You can assign more than two series, but each one must be set to a specific chart type.

PowerPoint offers three combo chart presets. The most useful is Clustered Column – Line on Secondary Axis. This preset creates a bar series on the primary axis and a line series on the secondary axis. The other two presets are Clustered Column – Line and Stacked Area – Clustered Column. The first places both series on the same axis, which can distort the line if scales differ. The second combines an area and column, which is less common for business presentations.

Steps to Insert a Combo Chart With Bars and Lines

Follow these steps to create a combo chart from scratch in PowerPoint. The process uses the built-in chart engine, which works identically in PowerPoint for Microsoft 365, PowerPoint 2021, and PowerPoint 2019.

1. Open a blank slide and insert a chart
   Go to the Insert tab on the ribbon. Click Chart in the Illustrations group. The Insert Chart dialog box opens.
2. Select the Combo chart type
   In the left pane of the dialog box, click Combo. The right pane shows three combo presets. Click the first preset labeled Clustered Column – Line on Secondary Axis. Click OK.
3. Enter your data in the Excel sheet
   PowerPoint opens an Excel window with sample data. Replace the sample data with your own. The first column holds category labels such as months or regions. The second column is the bar series. The third column is the line series. Close the Excel window when you are done.
4. Verify the chart layout
   PowerPoint creates a chart with bars for the second column and a line for the third column. The left vertical axis scales the bars. The right vertical axis scales the line. If the line appears flat or compressed, the secondary axis range may need adjustment.
5. Adjust the secondary axis range if needed
   Right-click the right vertical axis. Click Format Axis. In the Format Axis pane, set the Minimum and Maximum bounds to values that match your line data. For example, if your line data ranges from 60 to 100, set Minimum to 60 and Maximum to 100. This makes the line variation visible.
6. Format bar and line appearance
   Click the bar series to select all bars. Use the Format tab to change fill color, outline, or gap width. Click the line series to change line color, width, or marker style. Add data labels if needed by right-clicking a series and selecting Add Data Labels.

Convert an Existing Chart to a Combo Chart

If you already have a column chart and want to convert one series to a line, use these steps.

1. Select the chart
   Click the chart to activate the Chart Tools contextual tabs.
2. Open Change Chart Type
   Go to Chart Tools Design on the ribbon. Click Change Chart Type in the Type group.
3. Pick the Combo category
   In the Change Chart Type dialog, click Combo in the left pane. The right pane lists each data series with a drop-down menu next to it.
4. Assign chart types to each series
   For the series you want as bars, select Clustered Column from its drop-down. For the series you want as a line, select Line. Check the Secondary Axis box for the line series. Click OK.

Common Mistakes When Building Combo Charts and How to Avoid Them

Both series use the same axis and the line is invisible

When both series share the primary axis and one data set has much larger values, the line flattens into a straight line near the bottom. The fix is to assign the line series to the secondary axis. Right-click the line series, click Format Data Series, and select Secondary Axis in the Series Options pane.

The secondary axis scale does not match the line data

PowerPoint auto-scales the secondary axis based on the entire data range. If your line values range from 90 to 98, the auto-scale may start at 0, making the line appear flat. Right-click the secondary axis, click Format Axis, and set the Minimum and Maximum bounds to values just below and above your line data range.

Data labels overlap or are cut off

Bar data labels may overlap with line markers when both are positioned at the top of the chart. Reduce this by selecting the line series and changing its marker size to a smaller value. You can also move bar data labels to Inside End so they appear inside the bar instead of above it.

The chart does not update after changing data in Excel

PowerPoint stores a static copy of the data. If you edit the source Excel file outside of PowerPoint, the chart does not refresh. Right-click the chart and select Edit Data to reopen the embedded Excel sheet. Make changes there and the chart updates immediately.

Line series appears as a second set of bars

This happens when you accidentally select a column type for both series in the Change Chart Type dialog. Open Change Chart Type again, go to the Combo section, and set the second series to Line. Make sure the Secondary Axis box is checked for that series.

Combo Chart Presets in PowerPoint: Clustered Column – Line on Secondary Axis vs Clustered Column – Line

Item	Clustered Column – Line on Secondary Axis	Clustered Column – Line
Default axis assignment	Bars on primary axis, line on secondary axis	Both series on primary axis
Best use case	Data sets with different units or scales	Data sets with similar units and scale
Risk of distorted line	Low because line has its own axis	High if one series has much larger values
Post-insertion adjustment	Usually only need to adjust axis bounds	Must manually assign line to secondary axis

Use the Clustered Column – Line on Secondary Axis preset whenever your two data sets have different magnitudes or units. Use the Clustered Column – Line preset only when you are certain both series fit the same scale. In most business scenarios, the secondary axis preset saves time and prevents visual distortion.

You can now insert a combo chart in PowerPoint that combines bars and lines with separate axes. Start with the Clustered Column – Line on Secondary Axis preset to avoid common scaling errors. After entering your data, adjust the secondary axis bounds so the line variation is clearly visible. For a cleaner look, reduce the gap width of the bars to 50 percent in the Format Data Series pane. This makes the chart denser and more readable in slide layouts.