Jump to content



Photo

graphing scenarios in excel

excel

  • Please log in to reply
No replies to this topic

#1 capr

capr

    Neowinian Senior

  • Joined: 01-July 05

Posted 19 August 2013 - 22:21

Lets jump right in

 

A1=1

A2-A5 (something happens to A1)

A6=sum(A2:A5)

 

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?