On Feb 13, 1:55*pm, "mp" wrote:
"merjet" wrote in message

...

Yes. When you get to Step 2 of the Chart Wizard click on the Series
tab. Post again if you have questions about the input there.

If you have missing rows, the chart will contain gaps. If you don't
want gaps, copy the data elsewhere getting rid of the missing rows and
make the chart from the copied data.

Thanks, the only way I could figure out how to do it was copy the sheet and
delete everything except the two cols i wanted and delete all empty rows and
headers. *Couldn't figure out how to select the col for the x axis and the
col for the y axis.
I was hoping to find a way without duplicating the sheet data since I have
many sheets.
Didn't realize charts were so hard in excel, never tried them before.
Thanks for the suggestions

You could set up macros to do this automatically