![]() 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: 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: 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). 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |