[email protected] +1 303 779 0344

Home How-To

Project Portfolio Budget Report

How to create a Gantt chart for multiple projects in a portfolio and show which ones are over budget and under budget.

If you have multiple projects, you need a quick and easy way to see which projects in your portfolio are meeting their financial targets, and which ones are over budget. OnePager Express can create a Gantt chart for all of your projects, plus high-level budget information.

Project Portfolio Budget Report

15-Day
Free Trial

  1. Start with a simple Excel spreadsheet that lists all of the projects in your portfolio. This spreadsheet shows the dates, budget, and actual cost for each project:

    Excel spreadsheet showing the budget for each project in a portfolio.

  2. Launch OnePager Express. Don't have OnePager? You can download a free trial.

    OnePager Express: Easy Gantt charts from Excel.

  3. Click NEW to build a new project/portfolio report:

    OnePager Express for Excel

  4. Give your report a name, click Next, and then Create New Chart to get a first draft of your project portfolio budget report.

  5. Now, we want to add some of the budget vs. cost information from the spreadsheet into the Gantt chart. To do this, go to Home > Chart Properties > Rows/Swimlanes. In the Text Columns section, we'll add three columns: (1) the budgeted cost, (2) the actual cost, and (3) the overall project budget status:

    Show budget vs. actual cost information in your Gantt chart.

  6. With the budget vs. actual cost information now clearly showing in the Gantt chart, we now want things to stand out when they are over budget. To do this, we'll use conditional formatting. From the same Text Columns section, click on Manage Rules. We'll set up a rule that highlights cells in the second column (Actual Cost) when it's over budget:

    Projects that are over-budget will be colored red with conditional formatting.

  7. Let's add two more rules, this time for the third column, that displays a color-coded symbol to represent the overall budget status:

    Display a symbol to indicate the overall project budget status

    Here, projects that are under budget will show a green checkmark, while projects that are over budget will show a red x.

  8. Click OK to apply these settings, and you'll get a multi-project budget status report like this:
    A Gantt chart showing multiple projects in a portfolio and their planned vs. actual budget information.

Once you've built your budget report, it's easy to update each week or each month and your projects and your budgets change. No need to re-build the report from scratch; OnePager can import fresh data from Excel into an existing report, making tracking and updating your portfolio of projects very easy!

Get started today by downloading a free trial, complete with our world-class tech support.

15-Day
Free Trial