The advantage below is to show you how to start checking the trend type is the one you want and serves as the basis for expanding to loop over other series if needed. I also give an in sheet method for completeness. DataLabel.Text to write out the formula using VBA.