• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How do I get a percentage value

ROJPIX

New Member
from a trendline. I gather rainfall data and have a trendline in a graph and I want to express the trendline as a % drop in rainfall over 12 months
 
Send an Excel sample file, which has sample data as well as Your graph
... and Your expected results, even manually solved.
 
ROJPIX
Did You missed from
I want to express the trendline as a % drop in rainfall over 12 months
Your expected result, even manually solved?
 
=(TREND(B34:M34,,12)-TREND(B34:M34,,1))/TREND(B34:M34,,1)
formatted as a percentage.
 
Back
Top