Excel Chart Peak Detector
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
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