@JohnRennie hi sir excel doubt

Hi :-)

may i upload an excel sheet to your server

Yes

Done

OK I have it open

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.

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

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.

yeah I did it using this