Henderson for the Boston Consulting Group in This chart was created with the purpose of helping companies analyze their different business units or product lines. The analysis helps these companies to allocate resources where they are most appropriate as well as to use the results in brand marketing, product management, strategic management, and portfolio analyses.
Alesandra Blakeston Having used this type of chart a lot recently, I thought it was time I had a decent version in Excel. When complete, it should look something like this: You can download my sample chart here.
Set up your data To be able to plot a BCG matrix successfully, you need the following data: Create a bubble chart Highlight the first three columns of your table, in my case cells A1: Your bubble chart will look something like this: You can then delete the title, legend and horizontal gridlines by clicking on them and pressing the delete key.
You have to change the series X values. In this example we need to change it from column A to column E. Your BCG Matrix chart will update. Now, all of the values should be correct.
Right click on the X axis and then choose format axis. This value will change depend upon your data.
Without closing the formatting pop up menu box, click on the Y axis. The Axis value this time should be 0. Again, this value will change dependent on the data added. You can then press the close button. Your chart should now look like this: The bubble in the left upper quadrant is the star.
The bubble should then update with the picture.
The left lower quadrant is for the cow picture. The right upper quadrant contains the question mark bubbles, the right lower quadrant contains the dog bubbles.Boston Consulting Group (BCG) Matrix is a four celled matrix (a 2 * 2 matrix) developed by BCG, USA.
It is the most renowned corporate portfolio analysis tool. . BCG MATRIX Boston Consulting Group (BCG) Matrix or also called BCG model relates to marketing. This model is a known as portfolio management tool that used in product life cycle theory.
This model is a known as portfolio management tool that used in product life cycle theory. Therefore, this matrix is a matrix known as " Boston Consulting Group " or BCG matrix. This matrix allows the company to classify the products in its market share relative to its main competitors and the rate of annual growth in the industry.
BCG (Boston Consulting Group) Matrix The BCG Matrix - a portfolio strategy that managers use to categorize their corporation’s businesses by growth rate and relative Market share. o Helps managers decide how to invest corporate funds o Split into four categories based on how fast the market is growing and the size of the business’s share of.
CEMEX BCG MATRIX: A new strategy is developed for each business whenever any segment of firm competes in different industries. The Boston Consulting Group (BCG). BCG. Apply to be a consultant at BCG, or search our specialized and expert consulting roles.
Search and Apply for Roles. Apply for our business functions or for knowledge & research roles.