Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Question:

# Question:Q:How do I create a simple line graph in Numbers version 3.6.2?

I have the latest version OS 10.11.6 and Numbers version 3.6.2 and I would like to know how to create a simple line graph... I googled and can't seem to find anything to help me.

MacBook Pro, Mac OS X (10.7.4)

Posted on

The template shows where the numbers are. Click a graph, and then the Edit Data References rectangle to get a feel for how things work.

The numbers go into a table, and you base the graph on part or all of a table.

See where the x y are?

You would put your data where the x and y are. Then "connect the dots" to make a line (click the chart and look for this in the panel at the right).

And remove the formatting on the points if you want (click the line in the chart and look for this in the panel at the right).

The results, straight from the template, end up something like this:

It can be customized further as needed. Explore the tabs in the panel at the righ.

SG

Hi miinujo / ka,

Adding to these excellent replies (Scatter Plot), perhaps you are looking for a 2D Line Chart (graph).

The Charting Basics template (Basic Charts Sheet) does not illustrate this. So here we go...

A 2D Line graph is one of the Category graphs where the X-axis consists of discrete Categories (in your example, Day Number).

The X-axis has equally spaced values (ideally, one label for each Category).

For a Category graph, the X values must be in a Header Column, and the Y values must be in a non-Header column.

Row 1 is a Header Row.

You can enlarge the table to 90 days

Now stretch the graph to the right

The X-axis has room for only every second label (Day 1, 3, 5... to Day 89).

To include every day, stretch the graph further to the right

Good luck, this will not fit on one sheet of paper!

Hint, you can change the type of graph here:

And, yes, you can add a second line to a Scatter Plot or a 2D Line graph.

Regards,

Ian.

There’s more to the conversation

Create a table where your data will reside as the source of the chart:

make the first row a header rows to define the series by using the contextual menu of the first row:

now select columns A and B, then add a scatter chart from the Charts menu

Here is the table with the chart and no data. So enter some data:

With data

Nov 14, 2017 4:16 AM

Hi,

A very useful resource is the 'Charting Basics' template at File > New in your menu:

SG

Nov 14, 2017 7:56 AM

Thank you, Wayne~

I want to create a simple graph like this:

where on the vertical line it's numbered from 0-10 and the horizontal line is numbered 1-90...

I need very easy instructions since I am not graph-savvy 🙂...

Also, I may want to add a second line to the graph so it would show two different results..

Thank you very much!

~ka

Nov 14, 2017 12:25 PM

Thank you, SG~

I did see that, but I didn't know how to actually to the steps to create a graph (i.e. filling in the numbers where/how, etc..)...

🙂

Nov 14, 2017 12:26 PM

The template shows where the numbers are. Click a graph, and then the Edit Data References rectangle to get a feel for how things work.

The numbers go into a table, and you base the graph on part or all of a table.

See where the x y are?

You would put your data where the x and y are. Then "connect the dots" to make a line (click the chart and look for this in the panel at the right).

And remove the formatting on the points if you want (click the line in the chart and look for this in the panel at the right).

The results, straight from the template, end up something like this:

It can be customized further as needed. Explore the tabs in the panel at the righ.

SG

Nov 15, 2017 1:02 AM

Hi miinujo / ka,

Adding to these excellent replies (Scatter Plot), perhaps you are looking for a 2D Line Chart (graph).

The Charting Basics template (Basic Charts Sheet) does not illustrate this. So here we go...

A 2D Line graph is one of the Category graphs where the X-axis consists of discrete Categories (in your example, Day Number).

The X-axis has equally spaced values (ideally, one label for each Category).

For a Category graph, the X values must be in a Header Column, and the Y values must be in a non-Header column.

Row 1 is a Header Row.

You can enlarge the table to 90 days

Now stretch the graph to the right

The X-axis has room for only every second label (Day 1, 3, 5... to Day 89).

To include every day, stretch the graph further to the right

Good luck, this will not fit on one sheet of paper!

Hint, you can change the type of graph here:

And, yes, you can add a second line to a Scatter Plot or a 2D Line graph.

Regards,

Ian.

Nov 15, 2017 1:02 AM

Hi, Ian~!

Lol, I didn't realize how long 90 days would be... maybe I'll break it down to three 30-day charts... I'll have to re-read (slowly) your instructions to figure it out... As soon as I read "X-axis consists of discrete Categories...", my mind went flew away... x's & y's remind me of algebra/trigonometry and I zone out... 😁 I will try during the day (it's almost 11pm) when my mind is more awake and clear...

Thank you very much~!

~k 🙂

Nov 15, 2017 1:00 AM

Thank you very much, SG~!

This is like learning an alien language for me... I will give it a try during the daytime when my mind is clearer... 😁

~k

Nov 15, 2017 1:02 AM

Hi ~k,

Also, I may want to add a second line to the graph so it would show two different results.

If you want a Line graph with two (or more) Categories, it might look like this:

Each fruit is a distinct Category (the horizontal X-axis)

Values (numbers for the years 2016 and 2017) are the vertical Y-axis.

I you want a Scatter Plot, please see replies above.

Never, ever give up.

Regards,

Ian.

Nov 15, 2017 2:29 AM

Nov 15, 2017 3:34 AM in response to Yellowbox In response to Yellowbox

Edit: I was too late for the Edit time-out

If you want a Line graph with two (or more) Categories, it might look like this:

Correction:

If you want a Line graph with two (or more) Categories, lines it might look like this:

Regards,

Ian

Nov 15, 2017 3:34 AM

Hi, Ian~!

😕

Thank you~

~ka

Nov 20, 2017 12:12 AM

Hi ~ka,

Click anywhere in a table and Menu > Table > Header Rows (or Header Columns or Footer Rows)

or here:

Regards,

Ian.

Nov 20, 2017 1:33 AM

User profile for user: miinujo

Question: How do I create a simple line graph in Numbers version 3.6.2?