Thanks for the help to date, but I'm now stuck trying to use ImportSpreadsheet.
I have set up importspreadsheet to read in the data instead of import (as suggested below), but can't find much in the documentation to help me do anything with it. What do I do with the output from ImportSpreadsheet to define the first three columns as the X, y and Z positions? I've labelled them as X Y Z catch & prop in Import Spreadsheet, but now what? I need to use the catch column as the size control in Glyph & the prop column as the control for color in ColourMap, and have the Glyphs plotted at the XYZ locations. There are no connections, performance isn't an issue and there are only a couple of hundred samples per file so I can't see any advantage in exporting a DX format of each file. Please correct me if I'm wrong in this. > This is a problem if you're bringing these in as a general format. > The problem is, they will get built as two separate fields and you > will have to use Select to get to each of them. The problem is, then > you have problems using one for size and one for color. You're better > off using ImportSpreadsheet where you get the two columns as separate > components into one field. Then you can use Mark to do what you want > easily. > __________________________________________________ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/
