![bcg matrix bcg matrix](https://cdn.slidesharecdn.com/ss_thumbnails/bcgmatrix-130728021250-phpapp01-thumbnail-4.jpg)
Step 5: Right click on y-axis and click format axis. I also made changes to axis color to make more prominent. As my data is plotted till “2.00” and I have “0.0” as the minimum so half is 1.00.Ĭlick Labels and select low from the list of label position. “Under vertical axis crosses” select axis value and mention half of maximum relative market share is in your data or any other suitable figure. Change the minimum bound to 0 under axis options.
![bcg matrix bcg matrix](https://image.slidesharecdn.com/businesspolicyandstrategicmanagementbcg-130903130329-/95/slide-11-1024.jpg)
Step 4: Right click on x-axis > click format axis. Now that we have our chart ready, we need to make cosmetic changes to it like moving both axis in the middle to make four quadrants and give it a nice background to make things easy to understand.
#BCG MATRIX SERIES#
Simply click on any bubble to select the series and shuffle the quadrants of revenue and Market growth with each other. Step 3: In my case as chart isn’t plotted against with the right variables on y axis, so it will require an adjustment. A chart will be inserted that is probably not what we require. Go to Insert > charts group > click scatter chart button > click bubble chart. relative market share, sales revenue and Market growth %. Step 2: Once we have the data, simply select ONLY the figures of the last three columns i.e. Following is the data I used:Īll the numbers are given except the relative market share which is calculated by taking the ration of Market share % with best competitor market share. Step 1: For BCG matrix the data is quite straight forward. Following are step-by-step to get the chart with all the needed bits and rest is simple formatting: All you need is an appropriate data and the way to plot the bubble chart with few tweaks if needed. Here is the BCG matrix built right in Excel: Such presentation help take prioritizing and deciding what product to be given how much attention and resources.
![bcg matrix bcg matrix](http://managementstudyguide.com/downloads/images/msg/bcg-matrix.png)
BCG matrix is a strategic decision making technique that helps in resource allocation among different cost centers or cost objects by categorizing or ranking them based on their ability to generate cash inflows against cash consumption or cash outflows.īCG matrix helps putting products in four different quadrants of graph based on their relative market share and market growth.