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,