Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

BCG Matrix

189 views
Skip to first unread message

Jon Peltier

unread,
Feb 21, 2002, 4:06:37 PM2/21/02
to
Like a pie chart where each bubble is supposed to go?

I'm not sure how you'd do it easily and automatically (I can think how to do
it hard and automatically, if you want to pay me for a week's work <huge grin
here>). But the slow manual way would be to make little pie shaped images in
PowerPoint or some other graphics program (or maybe just maybe make a small
pie chart in Excel, the appropriate size, then copy as a picture and paste
back into the sheet), then paste them into the sheet. Now copy the
appropriate image, select the single data point it relates to, and Ctrl-V
paste it, and the image you copied will become the marker for that point.
Repeat as needed.

- Jon
_______

In article <6e7e01c1bb09$716be240$3bef2ecf@TKMSFTNGXA10>, ger...@mailbox.hu
says...
>
>I would like to have charts of BCG - Boston Consulting
>Group - matrix in Excel. It could be an extension of
>bubble diagram, every circle shows a market segment, for
>example, but every bubble (circle) must contain an slice,
>too, in order to present a market share of a company.
>
>Any tips or solutions are welcome.

Itsme

unread,
Feb 22, 2002, 2:34:46 PM2/22/02
to
it's not excel, but there is a free (limited) version of a program
named sc-graph:

http://www.smitconsult.nl/graph1.htm
http://www.smitconsult.nl/graph_support.htm

which makes a nice BCG matrix. You can use excel data as input for the
matrix

On Thu, 21 Feb 2002 13:06:37 -0800, jonpe...@yahoo.com (Jon Peltier)
wrote:

0 new messages