![]() ![]() Now, all of the values should be correct. ![]() In this example we need to change it from column A to column E. ![]() Highlight the Relative Market Share values. In the pop up menu that appears, click on the “Edit” button. Right click on the x axis and then choose “Select Data”. 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: 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 |