Creating a Bar Graph with Two Data Sets of Different Scales in Excel

1. Enter your data into Excel, with two sets of data, one for each axis.
2. Select the data you want to plot, including both sets of data. Click on the "Insert" tab and select "Clustered Bar" chart type.
3. Add the secondary axis by right-clicking on one of the data series and selecting "Format Data Series".
4. In the "Format Data Series" pane, select the "Series Options" tab and check the box next to "Secondary Axis".
5. Right-click on one of the bars and select "Format Data Series" again.
6. In the "Format Data Series" pane, select the "Series Options" tab and change the "Gap Width" to a smaller number, such as 25%.
7. Repeat step 6 for the other set of data, if necessary.

That's it! You should now have a bar graph with two data sets of different scales, plotted on separate axes and sitting side by side.