« first day (496 days earlier)   

7:04 AM
@JohnRennie hi sir excel doubt
 
Hi :-)
 
may i upload an excel sheet to your server
 
Yes
 
Done
 
OK I have it open
 
7:12 AM
so sir I wanted to plot IE vs VBE for different values of VCb
 
So you want the four curves of IE on the same graph, but the problem is their x value differ so you can't just use the x values from the first set of data.
 
yes
 
There are probably cunning ways to do this but there is also a simple hacky way that works for me. Give me a moment and I'll add a new sheet to your workbook to show you.
 
sir but before that
I have added some more values which I ahd left out earlier
so Let me upload the new version
 
I've done it now.
Grab my updated version from swarchive.ratsauce.co.uk/Physics/default.asp
You'll be able to see how it's done and apply that to your new version.
 
7:26 AM
Ah I see what you did there
 
It works because in an xy graph if any values are missing Excel just ignores them.
 
sir
I think theres an easier way
sir plor for one value of Vcb
say plot for Vcb=0
then right click, and theres an option for add data
 
I don't get that, but I have an old version of Excel (2010).
 
sorry I meant select data
 
Ah, OK, you can add the new data by clicking the Add button. Yes, that works.
 
7:51 AM
yeah I did it using this
 

« first day (496 days earlier)