View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.charting
HEK HEK is offline
external usenet poster
 
Posts: 46
Default Four Quadrant Bubble Chart in Excel?

Hello:
I am not sure if you need coloured quadrants. This can be done in Excel, by
plotting against yr variables on a 0-100% scale, i.e. yr Risk 0-100% and yr
Potential Benefits 0-100%. Take yr project size as parameter for yr bubble
diameter. In the plot area you cld choose a graded two-colour e.g. from red
to white diagonally, to visualise the attractiveness of the project, or use
the somewhat more elaborative yet elegant mechanisms Jon and Andy mentioned.
The size of the bubble gives a feel for the importance of yr project. This
principle can also be used to display products (bubble size is market share
or annual revenues), with market attractiveness and business position on the
XY axes. You cld even take it one step further and add arrows to the bubbles
to show which way it is heading at (with a combination chart).
HTH, GL,
Henk
"Andy Pope" wrote:

Hi,

Another option, which will allow retention of bubble chart, would be to
create a image which can be used as the plotarea fill.
I used MS Paint to create a 4 colour quadrent. Then as long as the chart
is divided evenly the effect works quite well.

Cheers
Andy

wrote:
Hello,

Looking for help on creating a four-quadrant bubble chart in Excel that
will depicts a Project Portfolio along the axes of Risk and Potential
Benefits. This is a common diagram used in Portfolio Management to
visualize how projects compare to one another (Four-quadrant BCG -
Star, Cash Cow, Dog, and Wildcat).

My question is can this chart be created in Excel. If not, can anyone
recommend a charting program or add-in to accomplish what I described.

Thank you for your attention,


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info