"Don Guillett" wrote in message
...
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

true, I assume you mean the copying of sheets and deleting of rows?
If I could create the chart via code it would be even more straight forward.
maybe i'll try recording a simple macro and see if i can figure out the
objects required to compose a chart