View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Tushar Mehta Tushar Mehta is offline
external usenet poster
 
Posts: 1,071
Default Four Quadrant Bubble Chart in Excel?

You don't need to do anything special. As long as you have -ve values, XL
will automatically adjust a bubble chart to include the corr. -ve axis.

Of course, you may need to set the axes max/min values to by symmetric. To
do that, double click each axis one at a time and from the Scale tab set the
max. and min. values appropriately.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article .com, aww91
@yahoo.com says...
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,