This tutorial shows you how to add a line to a chart, it combines two types of charts, column and scatter chart.

combine a column chart and a xy scatter chart12

The first step is to create a chart with only one series. You can see my data in cell range A1:B7.

  1. Select A1:B7
  2. Go to tab "Insert" on the ribbon
  3. Click "column chart" button

The excel column chart is created, shown in the picture below.

combine a column chart and a xy scatter chart

Add a second series

I have added more data for a second series in cell range A9:B11.

combine a column chart and a xy scatter chart2

This series will be a horizontal line on 140.

  1. Right click on chart
  2. Click on "Select Data..."
  3. Click "Add" button
  4. Select cell B9 for "Series name:"
    combine a column chart and a xy scatter chart1
  5. Select cell range B10:B11 for series values

combine a column chart and a xy scatter chart3

Excel colored the second series differently so you can distinguish them easily. There are only two columns in the second series because of the two cells we selected as series values.

Change series chart type

I am now going to change the chart type for the second series.

  1. Right click on the second series on the chart
  2. Click on "Change Series Chart Type"
    combine a column chart and a xy scatter chart4
  3. Select chart type "Scatter with smooth lines"
  4. Click OK button

The second series is now a red line between Jan and Feb.

combine a column chart and a xy scatter chart5

You can change the width and angle of the line by editing the values in cell range A10:B11.

Build a horizontal line

  1. Type 0.5 in cell A10
  2. Type 6.5 in cell A11
    combine a column chart and a xy scatter chart9
  3. Right click on chart
  4. Click on "Select Data..."
    combine a column chart and a xy scatter chart8
  5. Select series "y"
  6. Click on "Edit" button
    combine a column chart and a xy scatter chart7
  7. Select cell range A10:A11 for "Series X values:"
  8. Click OK
  9. Click OK

combine a column chart and a xy scatter chart10

Final customizations

These are the steps I made to remove gridlines, smaller line and change the second series name value.

  1. Click on a grid line
  2. Press Delete button on keyboard
  3. Double click on horizontal line
  4. Decrease line width
  5. Change line color
  6. Click Close button
  7. Type "Break even" in cell B9

combine a column chart and a xy scatter chart12

Download excel *.xlsx file

Combine a column chart and a xy scatter chart.xlsx