In this tutorial you will learn how to create BCG Matrix in Excel. BCG Matix is a chart which show you potential of your company’s products. BCG stands for Boston Consulting Group – this company created this chart for the first time.

Preparing Data to BCG Matrix

First you need some data. You need market growth, market share for all of your products and relative market share.

To get relative market share just divide market share of your product and market share of your largest competitor.

Inserting BCG Matrix

To insert BCG Matrix in Excel select columns A, B and C for all products. Market Growth will be values of Y axis. Market Share will be the bubble in the chart.