1. ## Chart/Trend/Growth help (2000/2003)

Hi All, i am trying to make a chart that looks at three years of data and projects the results for the next 3 years. I have a couple of questions.
I highlighted all the grades for 2005-2007 and used the autofill handle to drag them across, Is this the proper way I should do this?

When I did this some grades went over 100, Is there a way to keep them at the 100 ceiling OR have the chart line stop at 100,
I set the range on the Y axis to 105 so the 104 average would show. Because agrade cannot actually exceed 100. thanks

2. ## Re: Chart/Trend/Growth help (2000/2003)

Since grades cannot rise above 100, a linear or polynomial trend clearly doesn't make sense, so you'd have to use another model. But with only 3 data points, it is impossible to determine which model would best fit the data. Unless you already know what model you should use, you shouldn't try to extrapolate these data.

3. ## Re: Chart/Trend/Growth help (2000/2003)

<P ID="edit" class=small>(Edited by Jezza on 07-Apr-07 12:44. To extend the range to B53)</P>Hi there

I would go for an if statement in Cells B53:G53

In B53 put =IF(B52/50>100,100,B52/50) and copy across to G53.

Double click the trendline and change it to a Power...

4. ## Re: Chart/Trend/Growth help (2000/2003)

I have attached the workbook with one possible approach, but since - as I noted in my previous reply - the number of data points is very small, the choice is rather arbitrary: a 1-1/x model.

5. ## Re: Chart/Trend/Growth help (2000/2003)

Jerry, Hans -thanks for the solution. We have just been training for 3 years and we are up to about 1200 students annually, so this is demo is to demonstrate where we will be, I believe it is just what I want. Thanks again...I may be back <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

6. ## Re: Chart/Trend/Growth help (2000/2003)

What I meant was "Are our processes working"

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•