how to make multiple line charts

Question

Level 1

15 points

how to make multiple line charts

Hi folks,

How to make a multi-line line chart in numbers. I am graphing meters per second for 3 animals. The time is between 0 and 3 minutes, or 180 seconds. Distance is from 0 to 500 meters.

Am I missing something, or is this process somewhat convoluted in the MAC? I much prefer Windows for these kinds of things, but need to use the MAC for this.

Numbers under the Animals is meters traveled at those intervals.

Any hlep here? I'll keep searching for a simple solution.

Distance in Meters	E	Animal 1 - slower	Animal 2 - faster
0	0	0	0
1	0.1947	0.31152	0.09
50	9.73	15.568	4.5
100	19.47	31.152	9
150	29.2	46.72	13.5
200	38.94	62.304	18
250	48.67	77.872	22.5
300	58.41	93.456	27
350	68.14	109.024	31.5
400	77.88	124.608	36
450	87.61	140.176	40.5
500	97.35	155.76	45

MacBook Air, Mac OS X (10.6.1), HP printer software

Posted on Nov 12, 2015 6:29 PM

Reply

Answer 1

SGIII

Level 8

37,562 points

Nov 12, 2015 7:22 PM in response to Sailordog

Something like this takes a minute or so in Numbers (and can then be prettied up in the Format panel):

What may not be obvious if you are used to working in Windows applications is that in your Numbers table you need to have the first row defined as a Header Row and the first Column as a Header column before selecting all the cells and inserting a 2D Line Chart. "Header" rows and columns display as shaded in the example. One way to make sure you are working with the right type of table is to choose the one that looks like this:

Once you got your chart working, you can delete an unwanted series (perhaps the E here) by clicking that line in the chart and hitting the 'delete' key.

SG

Reply

Answer 2

Sailordog Author

Level 1

15 points

Nov 12, 2015 7:24 PM in response to SGIII

Thanks very much for the help on this, very kind to respond so quickly.

Best!

Reply