Ever wanted to know how to create a 3 axis graph in Excel? The other day I got a question from Todd, an EngineerExcel.com subscriber. He uses Excel to create charts of cam position, velocity, and acceleration. The industry-standard way of graphing this data is to include all three curves on the same chart, like …
If you have a scatter plot and you want to highlight the position of a particular data point on the x- and y-axes, you can accomplish this in two different ways. As an example, I’ll use the air temperature and density data that I used to demonstrate linear interpolation. In the scatter chart below, the …
There are two functions for calculating the inverse tangent or arctan in Excel. These two functions are ATAN and ATAN2 (“atan” is short for arctangent), and they each have specific uses depending on the desired results that you’d like to obtain and the inputs available. In general, I’d recommend using ATAN if: You are only …
Arctan Excel Functions: Use ATAN and ATAN2 to Calculate Inverse Tangent Read More »
I’ve discussed linear regression on this blog before, but quite often a straight line is not the best way to represent your data. For these specific situations, we can take advantage of some of the tools available to perform nonlinear regression or curve fitting in Excel. Curve Fitting in Excel with Charts Excel charts are …
Recently I wrote about linear interpolation in Excel and showed how to do this in a worksheet. In this post, I’ll show you how to wrap this entire process into a linear interpolation VBA function. This is an essential function to keep in your toolbox if you find yourself needing to interpolate from tables of …
Now that we have User Defined Functions under our belts, let’s take a look at Excel VBA subroutines. What’s an Excel Subroutine? Basically, Excel VBA subroutines are collections of code that carry out specified actions on a worksheet. Unlike UDF’s, they can change formatting of a workbook, delete cells/rows/columns/worksheets, and add data to any cell …
I’ve received several requests lately to discuss Excel Macros and VBA (Visual Basic for Applications), which is the programming language built into Excel and other Microsoft Office products. Excel by itself is so flexible that you can do many things without having to get into VBA. However, if you really want to increase the capabilities …
In the past, I’ve written about using the VLOOKUP function to pull data from tables into engineering calculations. However, you will probably find (if you haven’t already!) that as your spreadsheets become more sophisticated that VLOOKUP no longer gets the job done. For these situations, we can use Excel’s INDEX and MATCH functions to create …
Using Excel’s INDEX and MATCH Functions to Look Up Engineering Data Read More »
You’ll also receive regular tips to help you master Excel for engineering.
Learn advanced engineering techniques in Excel with this limited time free video training.
Click the button below to get started today.
