Gantt Chart Revenue Forecasting
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.
Comments
-
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
