How to Construct an Ogive in Excel (Step-by-Step Tutorial) with 2 Y-Axes

Learn how to create an ogive (cumulative frequency curve) in Excel using class upper bounds and cumulative frequencies. This tutorial walks you through calculating cumulative and relative frequencies, inserting a scatter plot, and customizing the chart with dual Y-axes, one for frequency and one for percent. 📊 Includes: • Step-by-step ogive construction • Dual-axis setup for frequency and percent • Chart formatting tips for clarity and presentation 00:04 - Step 1 – Create Upper Bounds 00:22 - Calculate Cumulative Frequencies 00:40 - Step 3 – Add a Starting Point 00:58 - Step 4 – Insert the Ogive Chart 01:32 - Step 5 – Add Cumulative Relative Frequencies 01:58 - Step 6 – Add a Second Y-Axis 02:35 - Step 7 – Format the Axes 02:54 - Step 8 – Hide the Second Line 03:15 - Step 9 – Add Axes Titles    • Frequency Polygon Graph in Excel | Beginne...