Nov 17 2022 08:28 AM
Hi there,
I'd like to produce a graph that shows the value of a portfolio of projects over time (current) including the value of projects with h/m/l probability of being won. The idea being that I'd like to see how the currently portfolio will be replaced by future projects.
Data for each project:
Project Code (not shown on graph)
Project value per month (used to produce y axis magnitude when stack with all other projects based on start/finish month)
Start: Month/Year and End: Month/Year (used to calculate x axis)
Code: Current/H/M/L
I can produce one 'long hand' by creating a month by month table, but I want to do it the quicker way of doing it just by start and finish date.
Darrin