1 of 1 people found this helpful
I see your title, but is there a reason you're unable to re-structure your data? I'm unsure if you can build a trendline without having your dates in the same column. If you pivot it you can do it very straightforwardly. Even with just having the "Q3-17" as your date column, you can parse this to convert into a useful date.
Thanks, didn't know I could do that! I've not yet managed to get it to work on my data but will figure it out.