High-Quality Executive Gantt Chart Creation

Summary
Build Executive-Level Gantt Chart in PowerPoint from Dependency Tracker (with Cascade Impacts)

Description

I am looking for an experienced PowerPoint / data visualization specialist to convert an Excel-based dependency tracker into a **high-quality executive Gantt chart presentation**.

The output must be **clean, visually compelling, and suitable for senior leadership (SteerCo level)**.

What I Will Provide

* Excel dependency tracker (fully populated)
* Includes:

* Dependency IDs and names
* Upstream and downstream programs
* Required dates
* RAG status (Red / Amber / Green)
* Impact levels
* Cascade impact descriptions (cause → effect chains)
* Impact category (Release, Program, Client, Financial)
* Critical flag
* Impacted milestone

What You Need to Deliver

1. Executive Gantt Chart (PowerPoint)

* Timeline-based Gantt view of all dependencies
* Bars aligned to **Required Dates**
* Color-coded by **RAG status**
* Clearly labeled dependency names (NOT IDs only)

2. Cascade Impact Visualization (Critical Requirement)

Each dependency must clearly show:

* What it impacts downstream
* How failure propagates (cascade effect)

This can be done via:

* Callouts
* Side panels
* Arrows or structured annotations

Example:
"Delays ISO testing → blocks FX readiness → risks April release"

3. Grouping & Structure

* Group dependencies by:

* Impacted milestone (e.g., April Release, FX Go-Live, Client Onboarding, Capital Drawdown)
* Highlight **critical dependencies**
* Ensure the slide is readable and not cluttered

4. Executive Summary Slide

Create 1–2 slides that summarize:

* Top 3–5 risks
* Key impacted milestones
* Any financial or release risk

5. Design Expectations

* Clean, modern, consulting-style (McKinsey/Bain level)
* White background
* Minimal clutter
* Strong typography and alignment
* Consistent spacing
* Easy to read in a meeting setting

Important Requirements

* Do NOT create a generic Gantt
* Must incorporate **cascade impacts clearly**
* Must be **exec-ready (not analyst-level clutter)**
* Must be editable in PowerPoint