Bubble Charts and Normalization

Bubble charts are common place in portfolio management processes. Without a designated portfolio management tool, I have designed bubble charts by hand using Excel and PowerPoint. To determine a ‘value’, we use our prioritization value scores and compare that among projects. We have risk scores as part of our prioritization criteria that drive the ‘risk’ portion of our bubble charts. The challenge in the past was how to interpret a score. Is a score of 500 good or bad?  Since my organization was experimenting with a new prioritization process, we didn’t know what was good or bad. Therefore, I made the decision to normalize the scores so that we could fairly compare good or bad projects within the portfolio rather than try to determine a threshold for ‘good’ projects. This has been helpful in identifying which projects drive more overall value to the organization compared to other current projects in the portfolio. The downside of this however, is that you are always going to have a few projects that look bad. Until now, I had been normalizing only among current projects in the portfolio, yet it suddenly dawned on me this morning, that I should also normalize among all projects, past and current in order to understand whether we get more value now than in the past.

One advantage of a bubble chart is to locate those projects that are higher value and lower risk and ask the question, “how can we get more of these types of projects in the portfolio?” Likewise with the lower value higher risk projects, we should ask how to avoid those types of projects. By normalizing with respect to past and current projects, we will see whether or not the projects are moving toward the higher value lower risk quadrant.

Tim Washington
Follow me

Tim Washington

I am the President at Acuity PPM. We deliver easy to use project portfolio management software to replace spreadsheets. If your PMO is still using spreadsheets to track and manage the project portfolio, contact us.

One thought to “Bubble Charts and Normalization”

Leave a Reply

Your email address will not be published. Required fields are marked *