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.