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.