I'm trying to look at a a count of patients by gender by month over Oct 2015 to Feb 2016. I want to add a trendline, so I made my date field MMM YY/continuous. A workbook is attached with fake data in the same format of my real data. The only ways I can figure out to do a trendline are like the pictures below. However, these are problematic, a)the formatting b)the second picture puts the months in the wrong order. Any suggestions?
and I did try
And add it to columns (replace trendbydimension)