Skip navigation

It is possible to develop a decent correlation diagram in Excel. This is an example of a single worksheet incorporated into a workbook with all of the other tabular data supporting a geologic map that I am making of the Owyhee River area, Oregon. Not only is this a good way to keep all of your data in one place (Arc 9.2 can incorporate Excel worksheets quite painlessly now), but this diagram can be directly linked to an mxd file of the map layout. This is a positive development for all concerned parties (the geology team and the cartography team). This sheet is stored amongst sheets that show the point codes, line codes, and unit codes and can be updated concurrently if you stay on top of it.

Note that there are not nearly as many color options in older versions of Excel. The diagram above was created in the newest version.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: