Two trendline questions
Hopefully someone can shed some light on two issues I am having. I am trying to compare hiring activity between four different functions, and am looking at the number of resumes reviewed per week. I have attached a screenshot of the card I am using, here are my questions:
1. The date labels are currently Excel format, but I want those to actually be Sunday-Saturday date ranges for the calendar weeks of the year labeled by date. Normally when I try to do WoW trendlines, the weeks are just labeled "Week 1 2020" or something like that.
2. The third week represents a week we had a company-wide event that suspended our talent acquisition function for a week. Currently, the trendline is broken, but I would like to make it zero. How would I go about doing this? Thanks for the help!