Excel trend line intercept
- by Brian M.
I have an Excel graph with a linear trend line to keep track of users who are updated with a newer version of software:
I have 660 users, and the trend line predicts where the number updated reaches 660 to indicate updates complete. Is there a way for it to either give me an actual value for that intercept, or, more conveniently, draw a vertical intercept line where the trend line is projected to hit that number?