Silly Chart Question

dlorenc

Board Regular
Joined
Aug 17, 2004
Messages
140
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?
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Forum statistics

Threads
1,223,275
Messages
6,171,121
Members
452,381
Latest member
Nova88

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top