Two Column Chart. Column charts display vertical bars going across the chart horizontally with the values axis being displayed on the left side of the chart. Go to DATA tab in the Excel Ribbon and click Sort A to Z command under Sort Filter group.
Select the first column product column except for header row. Overlapping columns can be used to visualize two data sets on a single chart. You need to change the original data firstly and then create column chart based on your data.
First set up a normal stacked column chart with all the data in it also the data for the line chart.
Overlapping columns can be used to visualize two data sets on a single chart. Start by making a plain old column chart. Right click the Secondary series choose Format Series or similar it varies with Excel version and select the Secondary Axis option. In such case you have to create the combination of the two chart types manually.
