As engineers and geologists, we frequently use Excel charts to communicate data…but which chart types are the best at communicating data, and which ones should be avoided? This is one Excel charting expert’s views on the issue. [Source: Peltier Tech Blog. Image: Peltier Tech]
Related Articles
Download Update: VBA and Excel…Part 2
My apologies to anyone in the past two months who tried to download my sample Excel spreadsheet that went along with the article " VBA and Excel for Engineers and Scientists – Part 2". I didn’t notice that there was a problem with the download until a new member emailed me about it (thanks Chris). I believe that it’s working now, if not be sure to email me! By the way, I’ve been out in the field since last week, sorry for the sparse posts.
Download the GeoPrac-VBA2-Examples.xls Spreadsheet (Excel 97-2003 format, but works with 2007 also)
Using Excel statistical functions for trend analysis
VBA and Excel for Engineers and Scientists
Visual Basic for Applications or VBA used in conjunction with Microsoft Excel is a tool that many scientists and engineers have yet to take full advantage of. This article is the first in a series designed to provide you with the basic understanding of how to use VBA and Excel in your practice.