excel

em_dogg · May 15th, 2002, 06:30 PM

when i am doing a chart on excel,
i have a line that is
x y
0 6
4 0
i want that to be one line, and i want a second line to be:
x y
0 8
4 0
how do i do this?

Mark W. · May 15th, 2002, 06:32 PM

Copy and Paste Special... the 2nd set of coordinates into the same chart as a new series. Apply the desired line formatting to each of the 2 series.

[ This Message was edited by: Mark W. on 2002-05-15 17:33 ]

em_dogg · May 15th, 2002, 06:35 PM

i have no idea what that means

Mark W. · May 15th, 2002, 06:50 PM

Okay, you learned how to graph the 1st pair of coordinates from your previous posting at http://www.mrexcel.com/board/viewtop...8473&forum=2&2.

Now, for the 2nd pair... Copy them, select the chart created above, choose the Edit | Paste Special... menu command and pick the "Add cells as New series" option.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 15th, 2002, 06:30 PM	#1
em_dogg New Member Join Date: May 2002 Posts: 4	when i am doing a chart on excel, i have a line that is x y 0 6 4 0 i want that to be one line, and i want a second line to be: x y 0 8 4 0 how do i do this?

May 15th, 2002, 06:32 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Copy and Paste Special... the 2nd set of coordinates into the same chart as a new series. Apply the desired line formatting to each of the 2 series. [ This Message was edited by: Mark W. on 2002-05-15 17:33 ]

May 15th, 2002, 06:35 PM	#3
em_dogg New Member Join Date: May 2002 Posts: 4	i have no idea what that means

May 15th, 2002, 06:50 PM	#4
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Okay, you learned how to graph the 1st pair of coordinates from your previous posting at http://www.mrexcel.com/board/viewtop...8473&forum=2&2. Now, for the 2nd pair... Copy them, select the chart created above, choose the Edit \| Paste Special... menu command and pick the "Add cells as New series" option.