Can this be done even?

T

Thrava

Hi,

It would help me enormously if I could draw a graph (say
with x axis being time, and Y axis being market rate
penetratio) and then have excel Extract the values of the
curve at some intervals.

the issue is that we like to play with the curve and use
the Y axis values corresponding to the graph we like be
used by Excel in a table.

can this be done?
 
E

Evan

The source table for an xy-chart is modified automatically
when you move a data point. Click a chart data point
slowly until you get a four-way arrow, and then move it.
If you want the data at intervals other than the chart
points, that' another story involving interpolation. I
haven't solved it except with a gory VBA routine.

Regards
Evan Weiner
Richland WA
 
E

Evan

If you want the interpolation, try:

Col A chart x-values, ascending
Col B chart y-values
Col D x-values, your choice
Col E fill with =MATCH(D1,A:A,1)
Col F fill with
=INDEX(B:B,E1)+(D1-INDEX(A:A,E1))/(INDEX(A:A,E1+1)-INDEX
(A:A,E1))*(INDEX(B:B,E1+1)-INDEX(B:B,E1))

Col F has the y-values corresponding to Col D.

If you use a smooth curve, then that's another story
again. It involves the Bezier curve, is involved, but
could be done in VBA.
 
Top