Piano man,

In step 2 of the chart wizard, go to the Series tab.  There you can select (and create, if
necessary) each series, and assign it to the columns of whatever sheet you want.  Select the
series you want, then put the cursor in the "Values" box, then switch to the sheet, select
the cells, and that's it.  Bob's your uncle.