I want the data in column 1 to be the Y axis scale and the data in columns 2
& 3 to show as a trend line in the chart. I have played with this 10 ways to
Sunday and can't find how to do this.

How do I identify the Row 1 to contain column headings. When I import it
asks me but I typed these in and it shouldn't be this well hidden.

Thanks in advance.

Try deleting the title in the first column
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Michael E W" <(E-Mail Removed)> wrote in message
news:FF137D6F-DB8E-4FA5-85EE-(E-Mail Removed)...
>I want the data in column 1 to be the Y axis scale and the data in columns
>2
> & 3 to show as a trend line in the chart. I have played with this 10 ways
> to
> Sunday and can't find how to do this.
>
> How do I identify the Row 1 to contain column headings. When I import it
> asks me but I typed these in and it shouldn't be this well hidden.
>
> Thanks in advance.

Thanks

"Bernard Liengme" wrote:

> Try deleting the title in the first column
> best wishes
> --
> Bernard V Liengme
> www.stfx.ca/people/bliengme
> remove caps from email
>
> "Michael E W" <(E-Mail Removed)> wrote in message
> news:FF137D6F-DB8E-4FA5-85EE-(E-Mail Removed)...
> >I want the data in column 1 to be the Y axis scale and the data in columns
> >2
> > & 3 to show as a trend line in the chart. I have played with this 10 ways
> > to
> > Sunday and can't find how to do this.
> >
> > How do I identify the Row 1 to contain column headings. When I import it
> > asks me but I typed these in and it shouldn't be this well hidden.
> >
> > Thanks in advance.
>
>
>