Excel Clustered Column Chart With a Line: How to Make One

Charts & pivot tables · Updated November 19, 2026

To make a clustered column chart with a line in Excel for Microsoft 365 on Windows, select your data, choose Insert > Insert Combo Chart > Create Custom Combo Chart, set the relevant series to Clustered Column or Line, and select Secondary Axis for the line if its values use a different scale. This combo chart puts side-by-side columns and a line in one chart, so you can compare related measures such as monthly sales and a target.

What a clustered column and line chart shows

A clustered column chart displays multiple column series side by side for each category. A line series connects values across those same categories. Combining them is useful when the columns represent amounts or counts and the line represents a target, rate, score, or other trend. For example, columns could show sales for two product groups each month, while a line shows the monthly sales target.

“Clustered” describes the arrangement of the columns: values for the same month are placed next to one another rather than stacked. The line is a separate data series, not a line drawn over the tops of the columns. Excel lets you choose the chart type for each series independently, which is why this is called a combination, or combo, chart.

A combo chart is most effective when the measures have a meaningful relationship and share categories, such as the same months or regions. It is not automatically clearer just because it fits more information into one graphic. If readers need to compare unrelated measures, separate charts may be easier to understand.

Arrange the source data first

Put categories in the first column and each data series in its own adjacent column. Use a clear header for every series, and keep one row per category. For example, a useful layout is Month, Product A, Product B, and Target, with January through December below Month. Excel uses the headers for the legend and the category labels for the horizontal axis.

  • Keep the categories in the same order for all series; do not sort one series separately.
  • Use actual numeric values for the measures. If a target is constant, repeat its value for every category so the line can be drawn across the chart.
  • Check that dates are real Excel dates, not text that only looks like a date. This helps Excel place and format the time axis appropriately.
  • Avoid blank rows and merged cells inside the data range, which can make Excel guess the series or category range incorrectly.

If you have a total column as well as two product columns, decide whether the total belongs in the chart. Plotting a total alongside its components can be redundant or visually confusing. You can leave it out of the selected range or remove that series after creating the chart.

Create the combo chart in Excel for Windows

  1. Select the complete data range, including the header row and category labels.
  2. On the ribbon, choose Insert > Insert Combo Chart > Create Custom Combo Chart. In some ribbon layouts, the combo-chart button appears in the Charts group under Insert.
  3. In the combo chart dialog, choose Clustered Column for the series that should appear as columns and Line for the series that should appear as a line.
  4. If the line series has a very different numeric range from the columns, check Secondary Axis for that series. Leave it unchecked when both types of values share a useful scale.
  5. Choose OK. Add or edit a chart title, axis titles, and legend as needed.

For an existing chart, select it and choose Chart Design > Change Chart Type > Combo. Set the chart type and axis option for each series in the dialog, then confirm. If Excel has guessed the wrong series or categories, use Chart Design > Select Data to correct the data range and series names before fine-tuning the combo settings.

On Excel for Mac, the combo-chart dialog and ribbon labels can vary by release, but use the Insert or Chart Design controls to choose a Combo chart and assign a type to each series. If a particular combo option is not available in Excel for the web or your installation, open the workbook in the desktop Excel app to create or adjust it.

Choose whether the line needs a secondary axis

A secondary axis gives the line its own vertical scale, usually displayed on the right side of the chart. It is helpful when the column values and line values differ greatly in magnitude. Suppose monthly sales are between 8,000 and 15,000 dollars, while the target attainment rate is between 0.80 and 1.10. Plotting both on one axis can flatten the percentage line near the bottom; a separate axis can make its movement visible.

That visual improvement comes with a trade-off: the left and right axes have independent scales. A line that appears to cross a column at a particular height does not mean the underlying values are equal. Label both axes with their measure and units, and use clear formatting so readers can tell which series belongs to which scale. If the values can reasonably share a single scale, a primary axis is usually simpler and avoids inviting misleading visual comparisons.

Do not choose a secondary axis solely to make a line look more dramatic. Set sensible minimum and maximum bounds for each axis only when the data and purpose justify them. A truncated scale can exaggerate small changes; an axis starting at zero is often appropriate for columns because column length encodes magnitude.

Format the columns, line, and labels

Keep the chart focused on the comparison. Give it a descriptive title, such as Monthly Sales and Target, rather than a generic title like Chart Title. If the secondary axis is in use, add axis titles that identify both the measure and unit—for example, Sales ($) on the left and Attainment (%) on the right. The legend should use meaningful series names rather than default labels such as Series 1.

Choose a line color that contrasts with the columns, and consider markers if readers need to identify the line’s value at each category. In Excel, select a series to open Format Data Series options; the exact pane controls depend on the selected series. You can also use Chart Design > Add Chart Element to add elements such as axis titles, data labels, or gridlines. Avoid labeling every column and every line point when the chart has many categories; overlapping labels can make the data harder to read.

For a crowded chart, reduce decorative effects, keep gridlines light, and make sure the line remains visible in grayscale or when printed. A thicker line or distinct markers can help, but avoid relying on color alone to distinguish series. If category labels are long, widen the chart, shorten labels where appropriate, or reduce the number of categories shown.

Read the chart without confusing scale and meaning

Columns are good for comparing discrete categories, while a line emphasizes movement across an ordered sequence. Months, quarters, and years have a natural order, so connecting their values usually makes sense. Connecting a line across unrelated categories, such as departments listed alphabetically, can imply a continuous progression that does not exist. In that situation, a scatter chart or separate display may be more suitable.

Also distinguish an actual series from a reference line. A monthly target entered as a value for each month is a data series and can be drawn as a line. A single benchmark may be better shown as a horizontal reference line, but Excel does not automatically turn a chart’s axis setting into that line: the benchmark needs to be represented as plotted data or added through a suitable chart annotation. Explain the benchmark in the legend or a label so readers know what it means.

Finally, remember that a line links the data points; it does not show values between categories as measured observations. With monthly data, the segment between January and February is a visual connection, not proof that the values changed at a constant rate each day.

Common problems and how to fix them

  • The line is almost flat or invisible: Check whether its values are on a much smaller or larger scale than the columns. Assign it to a secondary axis if a separate scale is warranted, and confirm the series contains numeric values rather than text.
  • Excel made every series a column: Select the chart, open Chart Design > Change Chart Type > Combo, and set the intended series to Line.
  • The months appear as separate series: Use Chart Design > Switch Row/Column to test the other orientation, then use Select Data to verify that the category labels and series are assigned correctly.
  • The line connects the wrong points: Check the category range and the source row order. Each line value should align with the intended category; remove stray cells from the selected range.
  • The line is hidden behind columns: Review the series types and formatting, and ensure the line is assigned as a Line series. Use a contrasting color and markers if necessary.
  • The axes make the chart hard to interpret: Add axis titles and units, simplify the scale, or remove the secondary axis if both measures can be read meaningfully on one axis.

When the chart still feels crowded, the problem may be the amount of data rather than a formatting setting. Showing fewer categories, splitting the measures into two charts, or simplifying the number of column series can be a more honest fix than shrinking the labels.

When another chart type is a better choice

Use a clustered column chart alone when the main task is comparing discrete groups and there is no distinct trend or target to emphasize. Use a line chart alone when the story is change over time and columns would add visual weight without helping the comparison. A stacked column chart is intended to show component contributions to a total, whereas clustered columns make side-by-side comparisons easier.

If the line values are measured on a continuous numeric x-axis, such as temperature against time recorded at irregular intervals, consider an XY (Scatter) chart rather than a standard category-based line. Scatter charts use numeric x-values; a line chart typically treats its horizontal labels as categories or dates. The right choice depends on whether equal spacing between categories is appropriate for the data.

Frequently Asked Questions

Can I put a line over clustered columns in Excel?
Yes. Create a Combo chart and assign the relevant series to Clustered Column and another series to Line. Choose a secondary axis for the line only if its scale needs to differ.

How do I add a target line to a clustered column chart?
Add a target column to the source data, repeating the target value for each category. Include it in the chart, then use Chart Design > Change Chart Type > Combo to change that series to Line. Decide whether it needs a secondary axis based on its units and range.

Why does my line look flat on a column chart?
The line may have values far outside the columns’ range, or Excel may be plotting it on the same axis as much larger values. Check the source values and consider a secondary axis, while labeling that axis clearly.

Can a combo chart use two column series and one line?
Yes. A common setup is two clustered column series plus one line series, all sharing the same categories. Set each series’ chart type individually in the Combo chart dialog.

Can I make this chart in Excel for the web?
Availability of combo-chart creation and editing can depend on the current web version and its interface. If you cannot find the needed Combo option or axis control, open the workbook in desktop Excel for Microsoft 365 and use the Insert or Chart Design combo-chart controls.

Related

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.