Simple Excel question - plot onto one graph

Smythe · 2014-03-03 17:27:31

On the attached Excel sheet I want to place all the values shown onto one graph which should show on it six different curves. The numbers in red are the horizontal x-axis, and the black numbers for the vertical y-axis. Would anyone know how to go about this? Thanks!

03-03-2014 05:27PM

#1

Smythe

Registered Users, Registered Users 2 Posts: 434 ✭✭

Join Date: March 2010

Posts: 232

On the attached Excel sheet I want to place all the values shown onto one graph which should show on it six different curves.

The numbers in red are the horizontal x-axis, and the black numbers for the vertical y-axis.

Would anyone know how to go about this? Thanks!

0

Comments

#2 03-03-2014 06:14PM
dmc17

Registered Users, Registered Users 2, Paid Member Posts: 3,868 ✭✭✭

Join Date: January 2010

Posts: 3836
Is it something like what I've attached? If so:
Use the first set of x & y values to create a scatter graph.

Click the chart, go to design tab and click 'Select Data'.

Add the 5 other ranges by clicking add series on the left of this dialog box

Click change chart type and change to scatter with lines

0
#3 03-03-2014 06:33PM

Smythe

Registered Users, Registered Users 2 Posts: 434 ✭✭

Join Date: March 2010

Posts: 232

Yes, that's it. Thanks very much for that dmc17, and for the explanation!

0
#4 03-03-2014 06:34PM

dmc17

Registered Users, Registered Users 2, Paid Member Posts: 3,868 ✭✭✭

Join Date: January 2010

Posts: 3836

Smythe wrote: »

Yes, that's it. Thanks very much for that dmc17, and for the explanation!

Most welcome.

0