Can I create a BCG Matrix in Numbers?

Question

Level 1

0 points

Can I create a BCG Matrix in Numbers?

I'd like to create a graph/matrix, which includes not only positional information (x,y axis), but also shows relative size. Ideally, it would be a BCG matrix much like Hans Rosling uses on www.gapminder.org.

Is it possible to create this with Numbers '09? Or, perhaps in Keynote?

iMac 27", Mac OS X (10.6.3)

Posted on Jun 10, 2010 8:16 AM

Reply

Answer 1

KOENIG Yvan

Level 8

41,819 points

Jun 10, 2010 8:21 AM in response to Jazeel

There is no provision for this kind of chart.

With a lot of time and patience, you may mimic them superimposing several scatter charts.

Yvan KOENIG (VALLAURIS, France) jeudi 10 juin 2010 17:21:52

Reply

Answer 2

Jazeel Author

Level 1

0 points

Jun 10, 2010 8:42 AM in response to KOENIG Yvan

Merci beaucoup, Yvan.

Reply

Answer 3

Badunit

Level 7

30,384 points

Jun 10, 2010 12:21 PM in response to Jazeel

If it is for a small number of data points, not like the graphic on the page in the link that has many points, you could get the look by plotting each data point as a separate series on the chart, choose a circular data point symbol for each series (you can do them all in one step by clicking on the chart but not clicking on a series, then choosing the round data symbol), set the size of the symbols to correspond with your relative size data (one at a time), then use a color fill for each to fill in center of the circular symbols (also one at a time). I wouldn't recommend this for more than a handful of points.

Reply