Step 3: Convert the chart to a BCG matrix You can then delete the title, legend and horizontal gridlines by clicking on them and pressing the delete key. Your bubble chart will look something like this: Then click on Insert > Other Chart > Bubble Chart. Highlight the first three columns of your table, in my case cells A1:C6. You can calculate the last by dividing the market share / market share of the largest competitor for example:Ī sample data table might look like this:
![bcg matrix template word download bcg matrix template word download](http://domsir.weebly.com/uploads/1/2/7/2/127205340/520956778_orig.jpg)
To be able to plot a BCG matrix successfully, you need the following data: market growth,market share, market share of the largest competitor, and relative market share. When complete, it should look something like this:
![bcg matrix template word download bcg matrix template word download](https://www.eloquens.com/i/p/3/3312/37202/1/bcg-growth-share-matrix-bcg-matrix-excel-template.png)
It basically shows you the potential of your company’s products.Ī BCG matrix is basically a bubble chart with a few tweaks. It is used to portray a company’s / SBU’s product portfolio on a quadrant showing relative market share (horizontal axis) and speed of market growth (vertical axis).
![bcg matrix template word download bcg matrix template word download](https://cdn8.bigcommerce.com/s-61110/images/stencil/2048x2048/products/30/121/BCG_Growth-Share_Matrix_Template_Excel__20986.1296234150.jpg)
In case you are not aware a BCG matrix, also known as a growth-share matrix is a management planning tool. Having used this type of chart a lot recently, I thought it was time I had a decent version in Excel.