On Sat, 5 Jan 2008, in microsoft.public.excel.charting,
said:

My problem is when I go to "Insert" and do "line chart", all the charts
have 2 lines and I have no idea how to get all the data on one line. My
teacher gave me step by step instructions but it was for the Excel 2003
program and I have Excel 2007 which is totally different. Any help
would be appreciated!!

Top tip Microsoft never tells you: if you selected the range including
headers at the top, omit the top left hand header. The blank cell will
clue the Chart Wizard that you expect that column to be the x axis, not
a data line. After you've created the chart, it's okay to give that
column a header too.

If you haven't included headers, then include one over the data column
and select that.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.