1 of 1 people found this helpful
I would start off by making real dates.
If I try to pop that into excel, it does all sorts of weird things to some of those dates. Consider spelling out the year: 2015, 2016, instead of just 2-digit years. Or put it in a format like mm/dd/yy. (Just use 01 for day.)
Otherwise consider having two columns, [month] and [year]. Just integers.
What you want to do is run months along the x-axis. Whether it is an integer value or a date value doesn't matter.
Do SUM([USD]) for your lines, and then put [YEAR] on the color shelf. You'll get a line for each year that way.