Produce a trend graph

Copper Contributor

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

 

 

0 Replies