I have 33 projects that have three values associated with them:
- project number
- a Project valuation (0,1,or 2) {equivalent to 'green', 'yellow', and 'red'};
- and a Project Manager Override Evaluation (0,1,or 2){equivalent to 'green', 'yellow', and 'red'}.
the table looks like this
Project ProjectEval PMEval
1 0 0 (green/green implies project is healthy)
2 1 1 (yellow/yellow project warning, pm agrees project warning)
3 3 3 (red/red project in trouble, PM agrees project in trouble)
and the variations
4 0 3 (project metric show green, PM sees trouble ahead)
5 3 0 (project metrics show red, PM indicates project trouble will be resolved)
I would like to produce a chart (dashboard) that plots the projects (almost like the magic quadrant) where the red/red's are in the upper right...green/greens lower left...
where Im stuck is that the label on each x/y pair should be the project number...not the x-axis label (assume we plot project eval on the x-axis, PMEval on the y)...
I think I'm thinking this chart is a three dimensional chart (Project/ProjectEval/PMEval)...but am trying to shoe horn it into a two dimensional chart...
how would YOU produce such a chart in excel?
- project number
- a Project valuation (0,1,or 2) {equivalent to 'green', 'yellow', and 'red'};
- and a Project Manager Override Evaluation (0,1,or 2){equivalent to 'green', 'yellow', and 'red'}.
the table looks like this
Project ProjectEval PMEval
1 0 0 (green/green implies project is healthy)
2 1 1 (yellow/yellow project warning, pm agrees project warning)
3 3 3 (red/red project in trouble, PM agrees project in trouble)
and the variations
4 0 3 (project metric show green, PM sees trouble ahead)
5 3 0 (project metrics show red, PM indicates project trouble will be resolved)
I would like to produce a chart (dashboard) that plots the projects (almost like the magic quadrant) where the red/red's are in the upper right...green/greens lower left...
where Im stuck is that the label on each x/y pair should be the project number...not the x-axis label (assume we plot project eval on the x-axis, PMEval on the y)...
I think I'm thinking this chart is a three dimensional chart (Project/ProjectEval/PMEval)...but am trying to shoe horn it into a two dimensional chart...
how would YOU produce such a chart in excel?