Want to Make a Line Column Combination Chart in Excel?
QI Macros Can Draw a Line-Column Chart in Seconds!
Create Line-Column Chart using QI Macros:
- Select your data.
- Click on QI Macros menu > Excel Charts > Line-Column.
- QI Macros will do the math and analysis for you.
A Line-Column Chart is used to Display Two Varying Sets of Data
A line-column chart combines a line graph and column chart on the same graph. The two charts share an X axis but each has its own Y axis. There are two common uses for a combination chart:
- when want to display two different data sets together
- when you want to display the sets of the same type of data but the ranges vary widely between the two.
Two Types of Data
![combination chart of car prices and number of cars sold](/excel-charts-qimacros/combination-chart-car-prices.png)
Two Sets of the Same Data Where the Range of Values Varies Widely
![combination chart of gas price comparison kuwait vs norway](/excel-charts-qimacros/combination-chart-gas-prices.png)
How to Create a Line Column Combination Chart in Excel
You can create a combination chart in Excel but its cumbersome and takes several steps.
- Select your data and then click on the Insert Tab, Column Chart, 2-D Column. Note: Make sure your labels are formatted as text or they will be added to the chart as a third set of bars.
- Next, right click on one of the data series and select Change Series Chart Type. Change the type to Line.
- Then, right click on the data series that does not have its values shown on the Y axis and select Format Data Series, Series Options, Plot on Secondary axis.
- A secondary Y axis will be added on the right side of the chart and the data series will be plotted against it.
![how to make a combination chart in excel](/excel-charts-qimacros/how-to-make-combination-chart-excel.png)
![change the series chart type](/excel-charts-qimacros/combination-chart-step3.png)
![series options plot on secondary axis](/excel-charts-qimacros/combination-chart-step4.png)
![line column chart](/excel-charts-qimacros/combination-chart-step5.png)
Save Time Using QI Macros Excel Add-in to Create Line-Column Charts
QI Macros will mistake proof your data selection and create a Line Column chart in one step. Just select your data and select Line-Column on 2 Axes from the QI Macros menu. QI Macros will prompt you for titles and create the line column chart in one step.
![qimacros line column chart](/excel-charts-qimacros/excel-combination-chart-qimacros.png)
![combination chart of car prices and number of cars sold](/excel-charts-qimacros/combination-chart-car-prices.png)
QI Macros also creates many more advanced charts in Excel.
Stop using old technology!
Upgrade Your Excel and Data Analysis Skills to Smart Charts Using QI Macros.
Track Data Over Time
![line graph](/images/tool-icons/line-graph.png)
Line Graph
![control chart](/images/tool-icons/control-chart-sm.png)
Control Chart
Compare Categories
![pie chart](/images/tool-icons/pie-chart.png)
Pie Chart
![pareto chart](/images/tool-icons/pareto-sm.png)
Pareto Chart
Analyze Variation
![bar or column chart](/images/tool-icons/bar-chart.png)
Bar or Column Chart
![histogram](/images/tool-icons/histogram-sm.png)
Histogram