Charts & Visual Data
Timeline Chart Formula: 4-Tier Alternating Callout Stem Heights Without Label Overlap
Stage collision-free horizontal Milestone Timeline Charts by cycling vertical error-bar/scatter stem heights across four alternating tiers (+H, -H, +0.5H, -0.5H) using MOD(Index - 1, 4).
Prevent overlapping milestone date labels on horizontal project timelines!
A horizontal Timeline Chart plots milestone dates along Y = 0 and extends vertical callout stems above and below the axis for text labels. Simply alternating +H and -H (2-tier parity) still collides whenever three milestones cluster within the same two-week sprint!
Cycling through a 4-tier stem sequence via Cycle_Slot = MOD(Milestone_Seq - 1, 4) alternates Outer-Top (+H), Outer-Bottom (-H), Inner-Top (+0.5*H), and Inner-Bottom (-0.5*H) — doubling horizontal label clearance before two stems ever share the same height!
| Milestone Sequence k | MOD(k - 1, 4) | Assigned Stem Height (Base H = 20) | Callout Placement |
|---|---|---|---|
| Milestone 1, 5, 9... | 0 | +20 | Outer Upper Tier |
| Milestone 2, 6, 10... | 1 | -20 | Outer Lower Tier |
| Milestone 3, 7, 11... | 2 | +10 | Inner Upper Tier |
| Milestone 4, 8, 12... | 3 | -10 | Inner Lower Tier |
4-Tier Staggered Milestone Stem Height Formula
Maps 1-based milestone sequence number B2 and outer stem amplitude B3 (> 0) into (+B3, -B3, +0.5*B3, -0.5*B3).
=IF(OR(B2 < 1, MOD(B2, 1) <> 0, B3 <= 0), "Milestone Index Must Be Integer >= 1 and H > 0", IF(MOD(B2 - 1, 4) = 0, B3, IF(MOD(B2 - 1, 4) = 1, -B3, IF(MOD(B2 - 1, 4) = 2, ROUND(0.5 * B3, 2), ROUND(-0.5 * B3, 2)))))Calendar Days Elapsed Since Project Kickoff Date
Computes integer day offset Milestone_Date - Kickoff_Date for proportional X-axis spacing.
=B5 - B4Try the example
Use the original values or change them to test your understanding.