Trend lines

**173** · 10-24-2008, 12:47 AM

I need to be able to take only the two most recent data points(from column A, as shown in column B), draw on a line graph the trend line connecting and extending beyond these two points. Any suggestions would be great.

Please Login or Register  to view this content.

Thank You

**Andy Pope** · 10-24-2008, 05:11 AM

What have you tried so far?

**173** · 10-24-2008, 04:12 PM

So far I've only tried the trend line command. Where I'm running into trouble is with the NA's. I also need to make sure it's clear that as data points are updated, only the most recent two points are used. THANKS

**Andy Pope** · 10-25-2008, 08:11 AM

are those na true #N/A's or just text?

How do you know which points are the most recent?

**173** · 10-25-2008, 10:10 PM

The #N/A is the result of an if statement in which true = a number value, and false = #N/A. The #N/A could be changed to say "0" if that would make it any easier.

If a condition is met, then a point (number value) is given, if the condition is not met, it gives the #N/A as a result. Data is added every minute automatically to the top of the list. A time stamp can be added to the corrisponding data entry, if it would help.

**Andy Pope** · 10-26-2008, 06:41 AM

This plots a trend line on the second data set.

**173** · 10-26-2008, 11:22 PM

Andy,

Once I flip the x-axis, the file you you provided shows exectly what I want. However, what is reffered to as column c, in your attatched file, was only an example of what I need. I don't know how to get that column.

What I need is to make c column from the b column. How do I make it only show the most two recent column entries from column b in column c.

Keep in mind a new number is being added to column b every minute. Therefore, B3's data moves down and becomes B4 after a minute( when the new data is added to the list in place of B1, B1's old data is moved down to B2). These cell references are from the file attatched. (trend problem)

Attatched is an example.

**Andy Pope** · 10-27-2008, 05:46 AM

If you only need the first 2 values then this formula, copied down will populate column C

=IF(COUNT(B$21:B21)<=2,B21,NA())

If not the first 2 then we need more information about which 2 points to use.