Marketing Plan - Gantt Chart - Weekly

Download and customize a free Marketing Plan Gantt Chart Weekly Excel template. Perfect for business, legal, and personal use. Editable and ready to boost your productivity.

Task	Start Date	End Date	Weeks
Task	Start Date	End Date

Weekly Gantt Chart Excel Template for Marketing Plan

This comprehensive Excel template is specifically designed as a Weekly Gantt Chart to support the planning, tracking, and execution of a comprehensive Marketing Plan. Unlike monthly or quarterly templates, this version provides granular visibility into daily and weekly marketing activities, enabling teams to manage campaigns with precision. The structure ensures that every task — from content creation to ad buy scheduling — is visualized on a timeline that aligns with real-world marketing cycles. Whether you’re managing a product launch, social media campaign, or multi-channel promotional strategy, this template transforms complex workflows into an intuitive visual roadmap.

Sheet Names

The template comprises three integrated sheets:

Marketing Tasks – The central data input sheet where all marketing activities are logged.
Gantt Chart View – A dynamic visual representation of the timeline using conditional formatting and bar charts.
Dashboard Summary – A high-level overview with KPIs, progress indicators, and milestone alerts.

Table Structure: Marketing Tasks Sheet

The Marketing Tasks sheet is structured as a table named “TaskList” with the following columns:

Name of the activity (e.g., “Launch Facebook Ad Campaign”)

The team responsible: Social Media, Content, SEO, Paid Ads, etc.

The Monday of the week when the task begins (e.g., 04/01/2025).

The Sunday of the week when the task concludes.

=INT((End Date - Start Date)/7)+1 — auto-calculated.

Current progress state.

Criticality level for resource allocation.

Name of the responsible team member.

List of Task IDs that must be completed before this task can begin (e.g., “3,5”)

Additions, links to assets, or deliverables.

Column Name	Data Type	Description
Task ID	Number (Integer)	Unique identifier for each marketing task.
Task Name	Text
Department	Text (Dropdown)
Start Date	Date
End Date	Date
Duration (Weeks)	Number (Formula)
Status	Text (Dropdown: Not Started, In Progress, Completed, On Hold)
Priorities	Text (Dropdown: High, Medium, Low)
Owner	Text
Dependencies	Text
Notes	Text

Formulas Required

To ensure dynamic functionality:

In column Duration (Weeks): =INT(([@[End Date]]-[@[Start Date]])/7)+1
In the Gantt Chart View, a helper column for each week (e.g., “Wk 1”, “Wk 2”) uses: =IF(AND([@[Start Date]]<=E$3, [@ [End Date]]>=E$3), 1, "") where E$3 is the week-ending date.
Status color logic in Dashboard Summary uses: =COUNTIF(TaskList[Status], "Completed")/COUNTA(TaskList[Task Name]) to calculate completion percentage.
To highlight overdue tasks: =AND([@Status]<>"Completed", [@[End Date]]



Conditional Formatting Rules
The Gantt Chart View uses color-coded bars:

    Green Bars: Completed tasks (cells with value 1 and Status = “Completed”)
    Blue Bars: In Progress tasks (value = 1 and Status = “In Progress”)
    Gray Bars: Not Started (value = 1, Status ≠ Completed/In Progress)
    Red Border: Overdue tasks (using formula above)


User Instructions

    Add all marketing activities to the “Marketing Tasks” sheet using the dropdown menus for consistency.
    Ensure Start Date and End Date always fall on Monday–Sunday weeks to match the Weekly format.
    Use “Dependencies” field to link tasks; incomplete predecessors will automatically highlight in yellow on the Dashboard.
    Update Status weekly during team syncs — this triggers automatic updates in the Gantt Chart View and Dashboard.
    Do not delete or reorder columns — all formulas depend on fixed column positions.
    To add a new task, copy an existing row and update fields; do not insert rows between existing data to preserve table integrity.


Example Rows
In Progress
3
04/01/2025
04/27/2025

    1 Launch Q3 Email Newsletter Campaign Email Marketing 04/01/2025 04/13/2025 2 High Jane Doe -Campaign copy approved 4/8, A/B test results pending.
    2 Create Instagram Reels (x6) Social Media 04/08/2025 04/27/2025 Not Started MEDIUM Marcus Lee 1Prior to email launch. Must wait for campaign assets.
    3 SEO Blog Refresh (x10) Content In Progress HIGH Alex Kim-
All posts scheduled via WordPress.


Recommended Charts and Dashboards
The Dashboard Summary sheet features:

    Total Tasks Completed (%) Pie Chart: Real-time progress indicator.
    Bar Chart: Tasks by Department: Shows workload distribution across teams.
    Status Timeline (Sparklines): Mini Gantt bars per task for quick scanning.
    Overdue Task Alert Box: Highlights any overdue items with red background and warning icon.


This Weekly Gantt Chart template turns abstract marketing goals into actionable, time-bound milestones. By enforcing weekly granularity, teams reduce ambiguity, improve accountability, and respond faster to delays. The integration of formulas and conditional formatting ensures that your Marketing Plan remains a living document — not a static PDF. Use it to align cross-functional teams, secure stakeholder buy-in with visual clarity, and turn campaign chaos into coordinated momentum.

⬇️ Download as Excel✏️ Edit online as Excel




		
                	Create your own Excel template with our GoGPT AI prompt:
			
       				 
 			         GoGPT

1	Launch Q3 Email Newsletter Campaign	Email Marketing	04/01/2025	04/13/2025	2	High	Jane Doe	- Campaign copy approved 4/8, A/B test results pending.
2	Create Instagram Reels (x6)	Social Media	04/08/2025	04/27/2025	Not Started	MEDIUM	Marcus Lee	1 Prior to email launch. Must wait for campaign assets.
3	SEO Blog Refresh (x10)	Content	In Progress	HIGH	Alex Kim - All posts scheduled via WordPress.