I'd like to have certain periods of the year shaded (as that of High, Low, Peak etc.)- to make it easier to see the seasonality in the data. Is there a way to pick a period each year which will be shaded? I work in two different excel files. The first shows the data linked to the chart and the second shows the seasonality in a calendar. The best for me would be a link between them, so as when I change the dates for High period in the calendar, this change should be shown on the chart. Is that possible? seasonality changes every week!
Chart+seasons.xlsx
Bookmarks