Welcome to electrical engineering with Excel. In this short video, we will make a peak detector, on an Excel chart. Often when analyzing data from a measurement input, it’s useful to know the maximum value of the data.
00:00 Intro
00:30 Start with a Simple Data Series
00:57 Creating Formula for Returning Peak Value
01:42 Excel Plots #NA Cells as Blanks
02:31 Fomatting Peak Marker
03:17 Pasting in Data and Formatting Chart
03:56 Formatting Frequency Numbers with SI Prefixes
05:10 Formatting the Data Callout
05:32 Adding Minor Gridlines and Dynamic Axis Titles
Continue this lesson in the app
Install CourseHive on Android or iOS to keep learning while you move.