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.
Step 1: Selecting Data Set to Create Column and Line Chart
- Firstly, select all the columns from the given data set.
Step 2: Using Charts Group
- Now select the Insert tab.
- then, select the Insert Combo Chart command from the Charts group.
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.
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.
- 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.
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.
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.