BCG Growth Matrix Chart in 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 the y axis in the chart and right click: 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%