Lets jump right in
A2-A5 (something happens to A1)
I want to graph A1 against A6 to show what happens to A6 as A1 gets bigger.
How do I do this? I know I can just dedicate a row to A1 and A6 and just copy the formula over. but that's not elegant. IS there a better way to just tell excel to do this?