Without seeing your actual (or at least sample) data, hard to tell; although, it sounds like with your data spread out among columns, this is making things difficult.

Can all the data be in a long column. That is 1/1/16 down to 12/31/16 in one column and the data in the second column?

Once you do this you can easily create pivot charts and group by data (month and years).