S'ok Guys, I managed to work it out by removing the empty cells.
Cheers!
On Thu, Mar 15, 2012 at 3:23 PM, cipherscribe
<adrian.mollenhorst@gmail.com>wrote:
> **
>
>
> 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
>
>
>
[Non-text portions of this message have been removed]
__._,_.___
----------------------------------
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
----------------------------------
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