Marketing Plan - Gantt Chart - Dashboard View
Download and customize a free Marketing Plan Gantt Chart Dashboard View Excel template. Perfect for business, legal, and personal use. Editable and ready to boost your productivity.
| Task | Start Date | End Date | Duration (Days) | Status | Progress (%) | Owner |
|---|---|---|---|---|---|---|
| Market Research | 2024-06-01 | 2024-06-15 | 15 | Completed | 100% | Jane Doe |
| Campaign Design | 2024-06-16 | 2024-06-30 | 15 | In Progress | 75% | John Smith |
| Social Media Launch | 2024-07-01 | 2024-07-15 | 15 | Not Started | 0% | Alex Johnson |
| Email Marketing | 2024-07-16 | 2024-07-31 | 16 | Not Started | 0% | Maria Garcia |
| Performance Analysis | 2024-08-01 | 2024-08-15 | 15 | Not Started | 0% | Chris Lee |
Marketing Plan Gantt Chart Dashboard View Excel Template
This comprehensive Excel template is designed specifically for marketing professionals and teams seeking to visualize, track, and manage their entire marketing plan through an intuitive Gantt Chart presented in a dynamic Dashboard View. Unlike traditional static Gantt charts, this template integrates interactive data input, automated scheduling logic, real-time progress tracking, and visual KPIs — all unified within a single dashboard interface. It transforms complex marketing timelines into an actionable roadmap that aligns campaigns with business goals.
Sheet Names
The template consists of four primary sheets:
- Marketing Plan (Data Input): The core worksheet for entering campaign activities, deadlines, owners, and resources.
- Gantt Chart (Visual Timeline): A dynamically generated Gantt chart using conditional formatting and bar charts to display task durations.
- Dashboard View: The executive-facing summary interface with key metrics, progress indicators, and interactive charts.
- Settings & Calendars: Hidden sheet containing holiday calendars, date configurations, and formula references.
Table Structures & Columns (Marketing Plan Sheet)
The Marketing Plan sheet contains the following structured table with defined data types:
| Column | Data Type | Description |
|---|---|---|
| ID | Number (Integer) | Unique identifier for each task. |
| Activity Name | Text | Name of the marketing activity (e.g., “Q3 Social Media Campaign”). |
| Type | Dropdown (Email, Social, PPC, Events, Content) | Categorizes task by marketing channel. |
| Start Date | Date (DD/MM/YYYY) | < td>Planned start date of the activity.|
| End Date | Date (DD/MM/YYYY) | < td>Planned end date of the activity.|
| Status | Dropdown (Not Started, In Progress, Completed, Delayed) | < td>Current status of the task.|
| Owner | Text | < td>Name or team responsible for execution.|
| Budget ($) | Currency | < td>Allotted budget for the activity.|
| Actual Spend ($) | Currency | < td>Real expenditure tracked manually or via integrations.|
| % Complete | Percentage (0–100%) | < td>User-entered progress value used to auto-adjust Gantt bar length.
Formulas Required
- In column Duration (Days):
=IF(AND([@Start Date]<>"", [@[End Date]]<>""), [@[End Date]] - [@Start Date] + 1, "") - In column Bar Start (Serial Number): Uses
=[@[Start Date]] - MIN(MarketingPlan[[#All],[Start Date]]) + 1to align bars with the dashboard timeline. - In column Bar Length (Days): Uses conditional logic:
=IF([@% Complete]=100, [@Duration], ([@% Complete]/100)*[@Duration])to dynamically shorten Gantt bars based on progress. - Status Color Logic: A helper formula in the Dashboard View uses
=COUNTIFS(MarketingPlan[Status], "Delayed")/COUNTA(MarketingPlan[Status])to calculate delay risk percentage. - Budget Variance:
=[@[Actual Spend]] - [@[Budget ($)]]with conditional formatting for overruns.
Conditional Formatting Rules
- Gantt bar colors: Green if 100% complete, yellow if “In Progress”, red if “Delayed” (status-based).
- Over-budget tasks: Highlight budget variance cells in red if actual spend exceeds planned budget by >10%.
- Upcoming deadlines: Any task with an End Date within 3 days and status ≠ "Completed" is highlighted in orange.
Instructions for the User
How to Use:1. Enter all marketing activities in the Marketing Plan sheet using dropdowns for Type and Status.
2. Input accurate Start/End Dates — do not edit dates directly in the Gantt Chart sheet; they are auto-generated.
3. Update % Complete weekly to reflect actual progress. This automatically adjusts the Gantt bar length.
4. Review the Dashboard View for real-time insights: Progress Trend, Budget Utilization, Channel Performance, and Critical Path Alerts.
5. Use slicers on the Dashboard to filter by Owner or Type to drill into specific campaigns.
6. Avoid inserting/deleting rows in the Marketing Plan sheet — use Excel Tables for safe expansion.
Example Rows
| ID | Activity Name | Type | Start Date | End Date | Status |
|---|---|---|---|---|---|
| 1 | Q3 Email Newsletter Series (4 campaigns) | 01/07/2024 | 31/08/2024 | In Progress | |
| 2 | <TikTok Influencer Campaign Launch | Social | 15/07/2024 | 30/09/2024 | Not Started |
| 3 | Digital Ad Retargeting (Google Ads) | PPC | 15/07/2024 | 31/10/2024 | In Progress |
| 4 | Marketing Automation Setup (HubSpot) | Content | 05/06/2024 |
*Note: Task #4 is marked as "Completed" with 100% progress — its Gantt bar will appear fully shaded.
Recommended Charts & Dashboard Components
The Dashboard View includes:
- Gantt Chart Bar Graph (Stacked Bar): Displays each task as a horizontal bar with color-coded progress. Uses the “Bar Start” and “Bar Length” columns.
- Progress Overview Pie Chart: Shows % of tasks completed vs. pending.
- Channel Performance Bar Chart: Compares budget spend and completion rate by Type (Email, Social, PPC).
- Timeline Heat Map: A monthly calendar grid with color intensity indicating number of active campaigns per month.
- Key Metrics KPI Cards: Total Tasks, On-Time Rate (%), Budget Utilization (%), Average Delay (Days).
- Slicers and Filters: Interactive filters for Owner, Type, Status — allows drill-down analysis.
This template turns raw data into strategic insight. By combining a robust Marketing Plan structure with the visual clarity of a dynamic Gantt Chart presented via an intuitive Dashboard View, marketing teams gain unprecedented control over execution, resource allocation, and timeline adherence — all within the familiar Excel environment.
This is not just a tracker — it’s your command center for high-impact marketing delivery.
⬇️ Download as Excel✏️ Edit online as ExcelCreate your own Excel template with our GoGPT AI prompt:
GoGPT