hlaverdiere1
New Member
- Joined
- Sep 14, 2008
- Messages
- 3
In Excel 2007, I am trying to create an aimline (not a trendline) that "stretches" across the variable chart dates (I have an =OFFSET with named ranges for dates and #correct), with up to 50 possible entries for each. The chart is of student reading fluency scores, ie. we record the date and the # of words correctly read. The aimline would be the minimum score a student at that grade level would be in the FALL to the SPRING minimum (ie. Fall would be 84 for a 3rd grader; Spring would be 76). With the dates being highly variable, not sure how to handle this one!