I have a static cell A that you type a number into, and I have another cell B that performs a bunch of calculations based on the value of A. Is there any way to plot a graph of the value of B as A increases? For example, for A=1 to 10 on the X axis, show me B on the Y axis.
Put the values 1 through 10 in A1 through A10
B1=yourfunction(A1), copy down through B10
Plot A1:B10 on a scatter plot using A1:A10 as the X values.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks