How do you do a Boston 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 create a matrix in Excel?

To create a matrix, you start with a table and convert it to a matrix. On the Design tab > Switch Visualizations > Table > Matrix.

How do you make a Boston 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 use the Boston Matrix?

To use the BCG matrix, a company will review its portfolio of products or SBUs, then allocate them to one of four quadrants based on their market share, growth rate, cash generation and cash usage. This is then used to determine which products receive investment, and which are diversified from.

How do you do a quadrant analysis in Excel?

Right-click on any of the four dots and pick “Change Series Chart Type” from the menu. In the “Chart Type” dropdown menu next to the two series representing the quadrant data (“Vertical line” and “Horizontal line”), choose “Scatter with Smooth Lines.”

Is there a matrix template in Excel?

If you choose to go with templates, there are many options available, including various weighted decision matrix templates, decision matrix excel templates or pugh matrix templates.

Can Excel do matrix math?

Matrix Multiplication with the MMULT Excel function You can multiply matrices in Excel thanks to the MMULT function. This array function returns the product of two matrices entered in a worksheet.

How do you calculate BCG?

Relative market share can be calculated in terms of revenues or market share. It is calculated by dividing your own brand’s market share (revenues) by the market share (or revenues) of your largest competitor in that industry.