How to Combine Bar and Line Graph in Excel (2025 Update)
In this article, we will explore how to combine a bar and line graph in Excel. Simply follow the steps below.
How to Add a Line Graph to a Bar Graph in Excel
To add a line graph to a bar graph in Excel, we will work with a dataset containing months of the year in Column A, dine-in revenue in Column B, and takeout revenue in Column C. Follow the steps below:
1. Insert a Custom Combo Chart with Your Revenue Data
First, highlight the range that includes your month labels and both revenue data series by clicking and dragging over the cells. Then, go to the ‘Insert‘ tab on the Excel ribbon. In the Charts group, click on the lower left arrow. This action will open an ‘Insert Chart’ dialog box.
In the dialog box, go to the ‘All Charts‘ tab. From there, select ‘Combo‘ to choose and customize your Combo Chart. This will allow you to combine bar and line graphs in a single chart using your data set.
2. Assign Chart Types to Each Revenue Stream in the Combo Chart
Make sure to assign different chart types to each revenue stream. Select a bar chart for the dine-in revenue to emphasize the total amounts, and choose a line chart for the takeout revenue to highlight trends over time.
3. Customize the Combo Chart to Improve Visual Clarity
Once the chart appears, you can modify the chart’s design under the ‘Design’ and ‘Format’ tabs. Here, customize the style and colors of the bars and line, add a chart title, label the axes, and insert a legend.
4. Review and Save Your Combo Chart to Ensure Accuracy
Review your chart carefully. Check that the chart accurately represents the monthly variations in dine-in and takeout revenues. Make sure the line and bars are correctly scaled and easily distinguishable. You can adjust the chart by clicking on the chart elements and using the options that appear.
We hope that you now have a better understanding of how to combine a bar and line graph in Excel. If you enjoyed this article, you might also like our article on how to add a line to a bar graph in Excel or our article on how to make a stacked bar chart with multiple series in Excel.
