**Question description:**

*This user has given permission to use the problem statement for this blog.*

if i draw a line with 3 point of mine , how can i make a table of values of many other points of the same line ?

Solved by G. U. in 27 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
10/06/2018 - 04:28

Hello

User
10/06/2018 - 04:28

hi

User
10/06/2018 - 04:28

it my first time here

User
10/06/2018 - 04:29

so can i ask about something

Excelchat Expert
10/06/2018 - 04:29

Yes of course

User
10/06/2018 - 04:29

if i draw something here it show on ur screen ?

User
10/06/2018 - 04:29

or i just tell u

Excelchat Expert
10/06/2018 - 04:30

You can draw at the fiew

Excelchat Expert
10/06/2018 - 04:30

view *

Excelchat Expert
10/06/2018 - 04:30

Or if you have an excel file you can attach it

User
10/06/2018 - 04:30

ok

User
10/06/2018 - 04:31

iif i draw a line with 3 points of mine

User
10/06/2018 - 04:31

and i want to extract many other point and put in on a table

User
10/06/2018 - 04:31

table

Excelchat Expert
10/06/2018 - 04:32

Ok

User
10/06/2018 - 04:32

how i extract them from gragh

Excelchat Expert
10/06/2018 - 04:33

if you draw a line form points, you can generate the equation of the line and make infinite number of points

User
10/06/2018 - 04:34

so i must get out the equation and put it into a cell and calculate ?

User
10/06/2018 - 04:34

did u see what i have draw now ?

Excelchat Expert
10/06/2018 - 04:34

Yes I see

Excelchat Expert
10/06/2018 - 04:35

yes you need equation for this

User
10/06/2018 - 04:35

yes do see the x axis

User
10/06/2018 - 04:35

its a date

Excelchat Expert
10/06/2018 - 04:35

Excel can generate this equation

Excelchat Expert
10/06/2018 - 04:35

yes

Excelchat Expert
10/06/2018 - 04:36

excel deal the date as a numbers

User
10/06/2018 - 04:36

i want to make a table but by days do u understand me

User
10/06/2018 - 04:36

i want calculate y when x = 60 day

User
10/06/2018 - 04:36

180

User
10/06/2018 - 04:37

and like that

User
10/06/2018 - 04:37

how i transform it

Excelchat Expert
10/06/2018 - 04:37

So change the Column B to be by dates

Excelchat Expert
10/06/2018 - 04:37

by days*

User
10/06/2018 - 04:38

aha i understood

User
10/06/2018 - 04:39

and generate equation and take points i need

Excelchat Expert
10/06/2018 - 04:39

Yes

Excelchat Expert
10/06/2018 - 04:39

Also you can make the equation with the dates

Excelchat Expert
10/06/2018 - 04:40

Look to the yellow cell at I16

User
10/06/2018 - 04:40

yes

Excelchat Expert
10/06/2018 - 04:40

it contain date

Excelchat Expert
10/06/2018 - 04:41

but if you change the format as number it show number of dates for that date

User
10/06/2018 - 04:42

42941 what is that number refer to

User
10/06/2018 - 04:42

or its random

Excelchat Expert
10/06/2018 - 04:43

no it is the number of days form year 1900

User
10/06/2018 - 04:43

aha i see

User
10/06/2018 - 04:43

can i make it form specific date ?

Excelchat Expert
10/06/2018 - 04:44

for example At J18 the date is 12/31/1899

User
10/06/2018 - 04:44

from 1/1/2008 for example

Excelchat Expert
10/06/2018 - 04:44

Which is the number 1

Excelchat Expert
10/06/2018 - 04:44

Yes

User
10/06/2018 - 04:44

i want make there refernce not 1900

User
10/06/2018 - 04:44

i want make it 2008 can i do that ?

User
10/06/2018 - 04:44

and how

Excelchat Expert
10/06/2018 - 04:45

by subtraction

User
10/06/2018 - 04:45

can u do it

Excelchat Expert
10/06/2018 - 04:46

Can you return the dates at B

User
10/06/2018 - 04:46

like that

Excelchat Expert
10/06/2018 - 04:46

Yes

Excelchat Expert
10/06/2018 - 04:47

At B I'll calculate the days form 1/1/2008

User
10/06/2018 - 04:47

make it from 3/1/2008

User
10/06/2018 - 04:47

the first date

User
10/06/2018 - 04:47

1/3

User
10/06/2018 - 04:47

sorry

Excelchat Expert
10/06/2018 - 04:48

Ok

Excelchat Expert
10/06/2018 - 04:48

Look at col A

User
10/06/2018 - 04:48

yes

Excelchat Expert
10/06/2018 - 04:48

It is the difference between the two dates

User
10/06/2018 - 04:48

aha

User
10/06/2018 - 04:49

just i subtract

User
10/06/2018 - 04:49

and value turnt into number it self

User
10/06/2018 - 04:50

u there?

User
10/06/2018 - 04:55

ok thank u too much for ur time

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*