Dual Bar Chart Excel. Select the data range and insert a chart first by clicking Insert and selecting a chart you need in the Chart group. The chart will be inserted for the selected data as below.
Make two y axis in chart. Here are three things that make bar charts a go-to chart type. From the Chart Elements menu enable the Axis Titles checkbox.
Axis Titles control Excel 20072010 add axis titles to the two vertical axes.
Stacked Column see screenshot. Continue to select each next bar of the second category by pressing the Right key on the keyboard and then press F4 to repeat the fill action. In the Charts group click on the Insert Columns or Bar chart option. Below are the steps to add a secondary axis to the chart manually.
