Make the y axis match when graphing two sets of data

You need to get used to the way that Excel matches the "category" axis for the bar chart (the left vertical axis) and the numeric axis (the right vertical axis). Typically, each category increments by 1 along the numeric axis, where n.5 is the division between categories. With that in mind, I would first try formatting the right vertical axis so that it's min is 0.5 and its max is 5.5.

Adjusting the area chart will be a little different. It is difficult to see from the picture exactly what you are using for the category/x data for the area chart. First thing I would do, because I expect to need to adjust the secondary horizontal axis separate from the primary horizontal axis, would be to add the secondary horizontal axis. Then I would look at the formatting on the secondary horizontal axis and see if it is using a text/category axis or a date axis. I would also make sure that I am using numeric data for the x axis data for this data series. If the secondary horizontal axis is defaulting to a text category axis, force it to be a date axis, then select appropriate min and max values for this axis. When all is said and done, I expect you won't want to see the secondary horizontal axis, so I would "hide" it by formatting it with no line, no tick marks, no labels, etc.