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

Question:

Question: 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

Reply
Question marked as Helpful

Nov 15, 2017 1:02 AM in response to miinujo In response to miinujo

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?


User uploaded file


User uploaded file


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).


User uploaded file


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).


User uploaded file


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


User uploaded file


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


SG

Question marked as Helpful

Nov 15, 2017 1:02 AM in response to miinujo In response to miinujo

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...

User uploaded file

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

User uploaded file

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

User uploaded file

Now stretch the graph to the right

User uploaded file

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

User uploaded file

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


Hint, you can change the type of graph here:

User uploaded file

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

Read all replies

Page content loaded

Nov 14, 2017 4:16 AM in response to miinujo In response to miinujo

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

User uploaded file


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

User uploaded file


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

User uploaded file



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

User uploaded file


With data

User uploaded file

Nov 14, 2017 4:16 AM

Reply Helpful

Nov 14, 2017 12:25 PM in response to Wayne Contello In response to Wayne Contello

Thank you, Wayne~


I want to create a simple graph like this:

User uploaded file

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

Reply Helpful
Question marked as Helpful

Nov 15, 2017 1:02 AM in response to miinujo In response to miinujo

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?


User uploaded file


User uploaded file


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).


User uploaded file


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).


User uploaded file


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


User uploaded file


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


SG

Nov 15, 2017 1:02 AM

Reply Helpful (1)
Question marked as Helpful

Nov 15, 2017 1:02 AM in response to miinujo In response to miinujo

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...

User uploaded file

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

User uploaded file

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

User uploaded file

Now stretch the graph to the right

User uploaded file

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

User uploaded file

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


Hint, you can change the type of graph here:

User uploaded file

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

Reply Helpful (1)

Nov 15, 2017 1:00 AM in response to Yellowbox In response to Yellowbox

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

Reply Helpful

Nov 15, 2017 2:29 AM in response to miinujo In response to miinujo

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:

User uploaded file

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.


Please reply with your overall aim.

Never, ever give up.

User uploaded file

Regards,

Ian.

Nov 15, 2017 2:29 AM

Reply Helpful (1)

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:

User uploaded file

Regards,

Ian

Nov 15, 2017 3:34 AM

Reply Helpful
User profile for user: miinujo

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