Hi All...........

I'm not much into higher math, or charting myself, but one of my users has
drawn a Scatter Chart and added a third order polynomial trendline to try to
pick up the missing value on the high end of his data...........Excel draws
the trendline on the chart just fine, but does not give a tickmark for the
corresponding value in question, rather gives just a formula in a Label-box
which when calculated by hand will give the desired value...........problem
is, my user wants Excel to calculate the value for him.........I have
managed this by Cntrl-C copying the formula out of the label box and
breaking it apart and doing the math, but this seems like the long way
around.........I can't "select" the formula out of the label-box...........

Question is, is there any way for Excel to do this calculation, or any way I
can "grab" that formula, maybe with VBA so as to do the calcs automatically?

TIA,
Vaya con Dios,
Chuck, CABGx3