Kamis, 15 Maret 2012

[ExcelVBA] Chart Object RSquard

 

Is it possible to extract the Rsquared value displayed on the chart and insert it into a cell reference? Ie, is this value an object?

I ask this since, although I know the formula for RSquared, I can't figure out how the chart plots my columns with all the empty cells, and given the x-axis is a date axis.

Cheers,

Adrian

__._,_.___
Recent Activity:
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------
.

__,_._,___

Tidak ada komentar:

Posting Komentar