[UW-GIS-L] scatterplot in excel

[Harvey Greenberg]

Are you trying to get an ascii file with 2 values for each pixel?  To do 
that, you would dump each band to ascii (assuming that the TM bands are 
separate grids) with GRIDASCII at the arc prompt in the black command 
window.  Then at the unix prompt (If you don't have one get one.):
tr -s '\012\015 ' '\012\012\012' < first_gridascii_dump |  sed 1,12d  > tmp1
tr -s '\012\015 ' '\012\012\012' < second_gridascii_dump | sed 1,12d  > tmp2
paste tmp1 tmp2 > file_for_excel.txt

Of course, a large geographic area would be overwhelming.
And this technique would not support the frequency of identical pairs.  
For that, you would combine (The grid COMBINE function will do this.) 
two bands in one grid, enter "tables" from the arc command, and UNLOAD 
the VAT.

I could flesh this out in detail, but I suspect that someone will 
convince you that excel is not the best tool for spectral analysis.

harvey


KT wrote:
> Hi all,
> I want to prepare a scatterplot of Landfsat TM bands, for instance, 
> band 5 versus band 7 in Excel. Is it possible? If not, how can I plot 
> this graph in excel?
> Thanks all
>
> ------------------------------------------------------------------------
> Do you Yahoo!?
> Next-gen email? Have it all with the all-new Yahoo! Mail Beta. 
> <http://us.rd.yahoo.com/evt=42241/*http://advision.webevents.yahoo.com/handraisers> 
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Uw-gis-l mailing list
> Uw-gis-l at u.washington.edu
> http://mailman1.u.washington.edu/mailman/listinfo/uw-gis-l
>   

-- 
hgreen at u.washington.edu  374 Johnson Hall 206-685-7981	
http://gis.ess.washington.edu/

	Harvey Greenberg
	University of Washington
	Department of Earth and Space Sciences
	Box 351310
	Seattle WA 98195-1310