MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Graph


Posted by Stephen Allenberg on February 01, 2002 8:22 AM

I would like to produce a graph of

i=a/(t+b)^c

for various times - t against the results - i.
I wish to plot a series of values of - t against the result i. I am only able to plot two individual graphs against the number of its numerical entry.

I would appreciate your help


Posted by Stephen Allenberg on February 01, 2002 1:27 PM

Posted by Stephen Allenberg on February 03, 2002 8:24 AM

Chris

Thanks for replying

Firstly I am not very familiar with Xcel programming (VB) if any is required.

The typical value I would use are

i=a/(t+b)^c

a=1024.6
b=6.64
c=.777
and t varying typical required are
5,10,15,20,25,30,60,120,240,360,480,720

I understand most of you reply except what to do in the paragraphs

"then in 1:1 ......" and

"then conditional format....."

"maybe play around......"


Regards
Stephen