Gantt Chart Revenue Forecasting

jruppert

I've built a sheet with all of our active projects and am wanting to predict revenue.

I am wondering if I can add expected revenue to milestones in a gantt chart and have it report monthly expected income as a report or on the chart itself somehow? I really just need a monthly total of expected revenue as I pile more and more projects in there.

Chris McKay

Hi,

You can definitely achieve what you're looking to do, but I need more info about what your data looks like and what you're hoping to achieve.

As a start, you can set the labels for your Gantt to anything you want by changing the Display label for setting in the Project Settings dialogue box.

If you have a Revenue Forecast column, you can use this. If you want to combine data, then create a new column and enter a formula like =Task1 + " - " + [Revenue Forecast]1 to create a more detailed label.

Kind regards,

Chris McKay