1) I want to create a chart using the data in my excel sheet.
2) Data in Row 1 should become the x-axis labels in a chart and data in Row 2 should be the y-axis labels and the only data range actually in the chart.
3) When I highlight data in Rows 1 and 2 then click on Chart Wizard both data
series are plotted and the X-axis values are 1,2,3.. etc.
4) Can the data in different Rows be plotted and named to have multiple line charts in a single chart?

Any ideas? Thanks in Advance!

Yes. Post up some data so I can see what you're dealing with.

Take a look at the data in this chart. It has Y-axis data across the top, and 3 X-axis data rows.

Highlighting the data and clicking the CHART icon starts an easy process of getting a multi-X-axis chart.