How do you insert a BCG matrix in Excel?

You can download my sample chart here.

  1. Step 1: Set up your data.
  2. Step 2: Create a bubble chart.
  3. Step 3: Convert the chart to a BCG matrix.
  4. Step 4: Format the BCG Matrix.
  5. Step 6: Add the coloured background.

How do you calculate the BCG matrix?

How To Make A BCG matrix?

  1. Step 1: Choose the product. BCG matrix can be used to analyse Business Units, separate brands, products or a firm as a unit itself.
  2. Step 2: Define the market.
  3. Step 3: Calculate the relative market share.
  4. Step 4: Find out the market growth rate.
  5. Step 5: Draw the circles on a matrix.

How do you create a matrix chart in Excel?

To create a matrix chart excel, the users need to follow these steps:

  1. Step 1: Open excel and arrange the Data.
  2. Step 2: Select Bubble Chart.
  3. Step 3: Stylize the Matrix.
  4. Step 4: Save the Matrix.
  5. Step 1: Select Matrix Template.
  6. Step 2: Customize Your Matrix.
  7. Step 3: Save and Share.
  8. Excel Matrix Template.

How do you make a 3×3 graph in Excel?

Go to Design tab. Click on Change Chart Type. Select XY Scatter plot….Add the X values by,

  1. Right mouse click on the chart.
  2. Click Select Data.
  3. Select the Dividers series.
  4. Click Edit.
  5. For the Series X values, highlight the X values from the table.

What is the formula for market growth?

Calculate market growth by subtracting the market size for year one from the market size for year two. Divide the result by the market size for year one and multiply by 100 to convert to a percentage.

What are the four quadrants of the BCG matrix?

Each of the four quadrants represents a specific combination of relative market share, and growth:

  • Low Growth, High Share. Companies should milk these “cash cows” for cash to reinvest.
  • High Growth, High Share.
  • High Growth, Low Share.
  • Low Share, Low Growth.

What are the four categories of BCG Matrix?

The BCG growth-share matrix contains four distinct categories: “dogs,” “cash cows,” “stars,” and “question marks.”

How do I make a matrix graph in Excel?