Project Portfolio Gantt

MelanieB
3StarLounger
Posts: 310
Joined: 19 Apr 2010, 16:18
Location: middle of the state of Washington

Project Portfolio Gantt

Post by MelanieB »

I have found a lot of Excel tutorials and templates for making a gantt in Excel for a project. They track tasks, etc.
I have tried editing them, but am struggling.
I need a gantt view of all of our projects - a portfolio of sorts.
I want to be able to filter it by the company Division that has the project (I.T., Power Delivery, Human Resources, etc.) or by the senior project manager; since our company often assigns multiple projects to a PM.

Any ideas of where something like this might already exist? I don't want to track tasks or risks or anything other than:
Sponsor, PM, Project Name, Project start/end dates.

chandoo.org has a project porfolio template I can buy but it is very complex and way much more than I need.

Your thoughts are much appreciated.

User avatar
HansV
Administrator
Posts: 78235
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Project Portfolio Gantt

Post by HansV »

I assume that you have tried
Gantt project planner
Gantt Charts in Microsoft Excel
Simple Project Planning With Excel Gantt Chart

It would be helpful if you could provide a sample of what the data look like (without sensitive information of course).
Best wishes,
Hans

LisaGreen
5StarLounger
Posts: 964
Joined: 08 Nov 2012, 17:54

Re: Project Portfolio Gantt

Post by LisaGreen »

Great links Hans! I really like the one from Jon Peltier.

User avatar
HansV
Administrator
Posts: 78235
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Project Portfolio Gantt

Post by HansV »

Jon Peltier is the real Excel charts wizard!
Best wishes,
Hans

MelanieB
3StarLounger
Posts: 310
Joined: 19 Apr 2010, 16:18
Location: middle of the state of Washington

Re: Project Portfolio Gantt

Post by MelanieB »

Thanks for the links! I managed to modify one from Jon Peltier.