Unique Excel Double Bar Graph With Secondary Axis

Right-click in the second price data series in the popup menu select Format Data Series.

Excel double bar graph with secondary axis. Excel puts it at the top of the chart by default. In the Charts group click on the Insert Columns or Bar chart option. To open the Format Data Series dialog box.

Right click the Secondary series choose Format Series or similar it varies with Excel version and select the Secondary Axis option. I am trying to make two columns of value show in a Column chart with two bars side-by-side. But whenever I try to move one series of data on secondary axis the chart automatically overlaps the two bars.

Right click on one of the variance series on the chart. Select Secondary Axis on the box that comes up. I tried to modify them but I can only make the bars wider.

Select Format Data Series then select Secondary Axis. Next to Percent of Nike Shoes Sold at the bottom click on the dropdown and select an option below Line. The legend is an indicator that helps distinguish the data series.

This is an optional feature however a secondary axis is commonly used in combo charts. Following are the steps you should follow to add a secondary axis to your Excel chart. This makes the chart hard to read.

Select and right click this secondary axis and then choose Format Axis from the context menu. The profit is shown on the secondary axis but because some of the points are negative the secondary axis starts at -5. Select a chart to open Chart Tools.