Finding intermediate points for graph plotting.

So, essentially the problem I have is this: I have 2 plotting points (V₁, P₁) and (V₂, P₂). These are the initial and final plot points for my curve. I am plotting a graph of P vs V. It is not acceptable to simply draw a straight line between these 2 points as they are modelled by the equation

Formula:

Please Login or Register  to view this content.

. What this equation says is, at any point on the curve, the value of

Formula:

Please Login or Register  to view this content.

is the same.

I would like to find about 100 intermediate plot points between the initial and final points and then plot the smooth curve (Which is defined by the equation

Formula:

Please Login or Register  to view this content.

) between them. How can I go about doing this in excel?

Is there a way that I can just input my initial and final points, the equation and the number of points on the line I want, and then have excel plot this line? Or, do I have to explicitly find all of the intermediate points and then select all of them and plot them in the usual way?

I see. I guess I could've been more clear. Thanks for the reply. See, I'll end up having about 100 data points by the time I'm finished and I just want to avoid having a spread sheet about 100 rows deep. So, judging from your sample code, if I want to plot this curve with 100 data points or so, I'm going to have to display all these data points in a spreadsheet, select them and then plot them as per usual, yes?

Ok, a follow on question, I have my initial value of V and final value of V. I've then split this range up into equal intervals of (Vfinal - Vinitial)/100. So, now I have a 100 values for V in a vertical column. Applying my formula P = C/V^g, where C and g are given in the adjacent column, I get 100 corresponding values for P. I can then go ahead and plot my graph of P vs. V. This all works out fine. Now, is there anyway that I can make it so that my graph of P vs. V updates automatically when I change my values of Vfinal and Vintial (Which will alter all the other values of V and P)?

Also, I'm fairly new to Excel and I'm not looking to write any code, such as VBA.

Gotcha. It essentially does it all by itself. Thanks for that!