I would recommend building a master calendar and creating a flag for the past 6 months. Then you can opt to ignore selections made in the application, such as other date fields and your chart is not impacted.
The chart would update for selections made in other fields such as departments, people, whatever is in your data. Maximizes your flexibility.
If this is of interest I'd be happy to share some code from a master calendar.