View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Four Quadrant Bubble Chart in Excel?

I meant to point out that the bubble variable shouldn't be used to try to
convey precise information to the audience. Judging values by area in one of
the worst ways a human can do it, with colors being about the only worse
approach. While it sounds like a great idea, you really can't do much better
than Small-Medium-Large.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"HEK" wrote in message
...
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