One of the things that makes Excel such a great tool is the ease at which you can automate certain tasks. This creates many opportunities for engineers to save time and prevent errors. One often-overlooked opportunity for automation is in chart titles and axis titles. Excel allows you to link the title of a chart …
The Colebrook (or Colebrook-White) equation is the best way to dynamically determine the Darcy-Weisbach friction factor for turbulent pipe flow. The equations were developed via a curve fit to many experimental data points. In the post below, I demonstrate how to create a Colebrook equation solver in Excel. Unfortunately, the equation is implicit (meaning that the …
What separates a skilled woodworker from anyone else who has ever picked up a saw? The answer is pretty obvious: He is excellent with his tools. He can take a common tool and produce uncommon results. The same is true for engineers. Skilled engineers take common tools and produce exceptional results. The Tools of an …
Often, engineers need to display two or more series of data on the same chart. In this section, we’ll add a second plot to the chart in Worksheet 02b. The first method is via the Select Data Source window, similar to the last section. Right-click the chart and choose Select Data. Click Add above the …
How to Quickly Add Data to an Excel Scatter Chart Read More »
At some point, you may need to change data that’s already plotted in an XY scatter chart. In our worksheet, we have the data from the previous section already plotted, but there’s an additional column of data in column D. In this section, we’ll look at three ways to change the chart to use the …
3 Ways to Change the Data in an Excel Scatter Chart Read More »
Although you’re probably familiar with basic cut, copy and paste operations in Excel, there are quite a few different options available when you paste data or formulas. It can be difficult to understand all these options at first. When you copy and paste data, a Paste Options button will appear at the lower right corner …
