How to Create Column and Line Chart in Excel (Step by Step)

On the same graph, a Column-Line chart combines a line graph and a column chart. An X-axis is shared by the two charts, but each has a separate Y-axis. A combination chart has two typical applications: when displaying two separate data sets simultaneously, as well as when displaying sets of the same sort of data but with vastly different ranges. In this article, we will show you how to create a column and line chart in Excel.


Download Practice Workbook

You may download the following Excel workbook for better understanding and practice yourself.


Step by Step Procedures to Create Column and Line Chart in Excel

Plotting diverse data sets with various chart styles or axes can be helpful for rapidly and effectively displaying data of various types. In this article, we will show you how to create a column and line chart using the 5 given steps below. To do so, we will apply the Combo Chart command and later on will alter the chart type using the Change Chart Type command. Let’s say we have a sample data set to show you how to create a Column and Line Chart in Excel using step by step procedures.

Sample Data


Step 1: Selecting Data Set to Create Column and Line Chart

  • Firstly, select all the columns from the given data set.

Sample Data


Step 2: Using Charts Group

  • Now select the Insert tab.
  • then, select the Insert Combo Chart command from the Charts group.

Step by Step Procedures to Create Column and Line Chart in Excel


Step 3: Creating Custom Combo Chart

  • Now click on the Clustered Column-Line command, which is marked with a red color rectangle.
  • Right-click on the chart.

Step by Step Procedures to Create Column and Line Chart in Excel

Read More: How to Create a 2D Clustered Column Chart in Excel


Step 4: Customizing Change Chart Type Box

  • Click on the Change Chart Type option.

Step by Step Procedures to Create Column and Line Chart in Excel

  • Here, the Line chart represents the average price of a car, and select the Clustered Column Chart to create a secondary axis for the number of cars sold.
  • Finally, click OK.

Step by Step Procedures to Create Column and Line Chart in Excel

Read More: How to Create a Stacked Column Chart in Excel (4 Suitable Ways)


Step 5: Creating Column and Line Chart

  • Here is the final result of our column and line chart.

Step by Step Procedures to Create Column and Line Chart in Excel


Conclusion

In this article, I’ve covered step by step process of creating a Column and Line chart in Excel. I sincerely hope you enjoyed and learned a lot from this article. Additionally, if you want to read more articles on Excel, you may visit our website, ExcelDemy. If you have any questions, comments, or recommendations, kindly leave them in the comment section below.


Related Articles

Bishawajit Chakraborty
We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo