Dual Bar Chart Excel. Of the many charts and graphs in Excel the bar chart is one that you should be using often. Youll probably also have to readjust the plot area.
Type the names of the two categories that the double bar graph. Make two y axis in chart. In the resulting chart select the profit margin bars.
From the Chart Elements menu enable the Axis Titles checkbox.
Select the data set Click the Insert tab. Select the data range and insert a chart first by clicking Insert and selecting a chart you need in the Chart group. Click on the OK. Basically you make sure each category of real data gap data equals 100.
