How to access chart filters on Excel for Mac

I am trying to filter data on the x-axis of a graph in Excel for mac but the filter button is greyed out. I've read in old forums that Microsoft hasn't made this feature usable. Is it not possible other than refinding the range needed? I need to change the range from Jan-Dec to June-Dec

Thanks,

Jack