Bcg Matrix Www.gazhoo.com

Boston Consulting Group (BCG) Matrix - Excel Template Goal: compare position of "our company" in the 5 markets M1 .. M5 using a BCG chart Market (MSFr)

M1

M2

M3

M4

M5

Our Company Competitor 1 Competitor 2 Competitor 3 Total 2001

1.00 0.50 0.25 0.25 2.00

0.50 1.00 2.50 0.00 4.00

1.00 0.50 0.00 0.00 1.50

2.00 0.50 1.00 0.50 4.00

0.50 0.00 1.00 0.50 2.00

Forecast 2003

2.25

4.5

2.5

5.5

3

Growth / year

6%

6%

29%

17%

22%

M1 2.00 6% 2.0

M2 0.20 6% 4.0

M3 2.00 29% 1.5

M4 2.00 17% 4.0

M5 0.50 22% 2.0

Note: to give the equation on how to compute a compound growth =POWER(10;LOG("Market,Forecast 2003"/"Market, Total 2001";10)/2)-1 Note: 2 corresponds to 2 years 2003 - 2001)

BCG Chart (simple version) Table 1: Title X axis (relative share) Y axis (market growth) radius

Note: size of company / biggest of its competitor =+"Market,OurCompany"/MAX("Market,Competitor1":"Market,Competitor3")

Note: simple bubble chart (without labels on datapoints) can be made quickly on the simple table 1 How to do it: 1 Select the range C36:G38 (yellow area) 2 Select the Chart Wizard with chart type: bubble chart

40%

30%

2 Select the x axis in the chart and right click 3 Select in the menu: Format axis / Scale: (x) min 0.1, max 10; log; inverted

20%

10% 10.00

1.00

0.10

4 Select S l t the th y axis i in i the th chart h t and d right i ht click: li k 5 Select in the menu: Format axis /Scale : (y) min 0.1, max 0.4 (format percentage)

0%

6 Select one bubble in the chart and right click: 7 Select in the menu: Format data series / Options: area of bubbles or width of bubbles

BCG Chart (more elaborate version) Table 2:

M1 2.00 0.20 2.00 2.00 0.50

6%

x

y

M2

M3

M4

6%

4.0 29%

radius

y

radius

y

1.5

radius

30% M1 M2

M5 20%

M3

M4

M4 M5

10% 1

M2

4.0

y

radius

22%

2.0

y

radius

How to do it: 1 Select the range C56: M62 (in yellow) 2 Select the Chart Wizard with chart type: bubble chart

M3

M1

17%

Note: more elaborate bubble chart - showing labels for datapoints - this chart can be made only with a more complex table as shown in table 2

40%

10

M5

2.0

0.1

3 Select the chart and then in Excel menu: 4 Menu chart / Source Data / Data Series / Name: for each serie, select cell with name of serie (e.g. D46, F46, …) 5 Menu chart / Chart Options... / Data Labels: select Series Names (to have names close to bubble) 6 Select the x axis in the chart and right click 7 Select in the menu: Format axis / Scale: (x) min 0.1, max 10; log; inverted 8 Select the y axis in the chart and right click: 9 Select in the menu: Format axis /Scale : (y) min 0.1, max 0.4 (format percentage) 10 Select one bubble in the chart and right click: 11 Select in the menu: Format data series / Options: area of bubbles or width of bubbles

0%