trying to plot y against x
 

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

trying to plot y against x
 

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

"ernestgoh" wrote in
message ...

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