Thread: Trendline that ensure maximum staff coverage

Hi all i have a forecasting model that averages the volume of calls based on the day and tie of year and spits out a suggested volume of staff required.

however because every half hour calls may drop then rise i wanted a trendline that will not go below my suggested staffing volume but only hit the highest points of actual forecast. this way enough staff are on to take calls and not too many are on when it's quiter

i hope that's clear (probably not) anu ideas are appreciated

What about creating a series of data that contains only the values you want to include in the trendline?

Failing that you may need to calculate the trendline out side of the chart if the criteria is too complex for simple trendlining.

Cheers andy i have kind of sorted it now but it's a bit of a bodge job!!