3 Replies Latest reply on Nov 19, 2011 4:58 AM by Joe Mako

    Display Project Count on a Project Portfolio Funnel Graph

    Dave Cohen

      I have a project portfolio funnel graph that displays projects superimposed on a background image.

       

      The display of the projects on top of the background image works fine.

       

      However, I would also like to display the # of projects for each status/phase combination in the funnel graph worksheet.

       

      The possible statuses are Red, Yellow, Green and Unavailable.

      The phases are 0, 1, 2, 3 and 4.

       

      In the attached packaged workbook, there is a dashboard that shows 3 worksheets.

       

      The worksheet in the top left is titled: Project Count, by Phase.  This worksheet shows a project count for each status and phase and displays the information that I would like to see.

       

      The worksheet in the bottom left is the funnel graph with marks displayed for each status and phase.  However, on this funnel worksheet, I am not able to figure out how to display the project count for each status and phase.

       

      Thanks,

       

      Dave