trying to plot y against x

[ernestgoh]

hi guys, can anyone help me out?

when i select line option in charts, excel keeps drawing a chart with two lines. what i really want is to plot $ as my y axis and t as my x axis (in example below). how do i do it?

$ t
10 1
20 2
25 5
40 7

appreciate any advice. thanks.

[Mike Middleton]

See reply in microsoft.public.excel, and please do not post multiple
messages.

"ernestgoh" <[email protected]> wrote in
message news:[email protected]...
>
> hi guys, can anyone help me out?
>
> when i select line option in charts, excel keeps drawing a chart with
> two lines. what i really want is to plot $ as my y axis and t as my x
> axis (in example below). how do i do it?
>
> $ t
> 10 1
> 20 2
> 25 5
> 40 7
>
> appreciate any advice. thanks.
>
>
> --
> ernestgoh
> ------------------------------------------------------------------------
> ernestgoh's Profile:
> http://www.excelforum.com/member.php...o&userid=24870
> View this thread: http://www.excelforum.com/showthread...hreadid=571456
>