How to Create a Matrix Chart in Excel

A matrix chart can turn a confusing spreadsheet into a clear, strategic tool, helping you map out complex relationships in your data. Whether you're plotting product performance or prioritizing tasks, this visual format brings instant clarity. This tutorial will walk you through exactly how to create a custom matrix chart in Excel, step-by-step, transforming your raw data into an insightful, four-quadrant graphic.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What is a Matrix Chart?

A matrix chart is a data visualization tool that displays the relationship between two or more sets of data in a grid or quadrant format. They are especially useful for strategic business planning and analysis because they present complex information in a simple, visual framework. You've probably seen them before, even if you didn't know their official name.

Some of the most popular business applications for matrix charts include:

• BCG Matrix (Boston Consulting Group): This classic strategic tool helps companies analyze their product lines or business units. It plots market growth rate against relative market share to classify products into one of four categories: Stars, Cash Cows, Question Marks, or Dogs. This helps leaders decide where to invest, what to harvest, and what to divest.
• Ansoff Matrix: This matrix is all about growth strategy. It charts products (existing vs. new) against markets (existing vs. new) to create four growth strategies: Market Penetration, Product Development, Market Development, and Diversification.
• Eisenhower Matrix: A popular productivity tool, this matrix helps prioritize tasks by plotting them based on importance and urgency. The four quadrants are Do, Decide, Delegate, and Delete, helping you focus your attention on what truly matters.
• SWOT Analysis: While often a simple list, a SWOT analysis (Strengths, Weaknesses, Opportunities, Threats) can be visualized as a 2x2 matrix, mapping internal factors (Strengths, Weaknesses) against external factors (Opportunities, Threats).

By arranging data into these quadrants, you can quickly spot patterns, identify correlations, and make more informed decisions. Excel doesn't have a one-click "Matrix Chart" button, but you can build a powerful, professional-looking one by customizing a Scatter or Bubble chart.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Your Step-by-Step Guide to Creating a Matrix Chart in Excel

We’ll build an Excel matrix chart using a common business scenario: a BCG Matrix for product portfolio analysis. This is a great example because it involves plotting items (products) across two different scales (market share and growth rate) and often includes a third data dimension (revenue), which we can represent with bubble size.

Step 1: Prepare and Structure Your Data

Proper data setup is the foundation of a good chart. For a matrix chart, you need a data table with separate columns for the items you want to plot and their corresponding X-axis and Y-axis values. If you're using a bubble chart, you'll need a third column for the bubble size.

Let's imagine we're analyzing a fictional software company's product line. Here’s what our data looks like. We've set it up with columns for Product Name, Relative Market Share (X-Axis), Market Growth Rate % (Y-Axis), and Annual Revenue (Bubble Size).

Step 2: Insert a Bubble Chart

With your data table ready, it's time to insert the chart. We're choosing a bubble chart because it allows us to represent three dimensions of data at once: market share on the X-axis, market growth on the Y-axis, and revenue as the size of each bubble.

1. Click and drag to highlight the numerical data in your table - in our case, the columns for Market Share, Market Growth, and Revenue. Do not include the header row or the product names yet.
2. Go to the Insert tab on the Excel ribbon.
3. In the Charts group, click on the icon for Scatter (X, Y) or Bubble Chart.
4. Select the Bubble chart option.

Excel will instantly generate a basic bubble chart. It won't look like a matrix yet, but placing the data points on the plot is our starting point.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 3: Define Your Quadrants by Formatting the Axes

This is where the magic happens. We'll format the axes to intersect at a specific point, which divides the chart into our desired four quadrants. For a BCG matrix, you typically define the split between "high" and "low" for both market share and market growth. Let's assume the midpoint for market growth is 10% and for relative market share is 50%.

Format the Vertical (Y) Axis:

1. Right-click on the vertical (Y) axis of your chart (the numbers that represent Market Growth) and choose Format Axis.
2. In the Format Axis pane that opens on the right, find the section called Horizontal axis crosses.
3. Select Axis value and enter the number where you want the Y-axis to split. For our BCG matrix, this would be the 10% growth mark, so we'll enter 0.10. This moves the X-axis up to that level, creating a dividing line.

Format the Horizontal (X) Axis:

1. Now, right-click on the horizontal (X) axis (representing Market Share) and choose Format Axis.
2. In the Format Axis pane, find the section called Vertical axis crosses.
3. Select Axis value and enter the value where your X-axis should split. For our example, the market share midpoint is 50%, so enter 0.50. This moves the Y-axis to create the vertical dividing line.

After adjusting both axes, your chart will now be split into four clear quadrants. You've officially created the framework of the matrix!

Step 4: Add and Format Data Labels

Our chart shows the bubbles, but we don't know which product is which. Let's add the product names as labels.

1. Click on one of the bubbles in your chart. This should select all the bubbles in the data series.
2. Click the + button (Chart Elements) on the top right corner of the chart.
3. Check the box for Data Labels, then click the small arrow next to it and select More Options…
4. In the Format Data Labels pane that opens, you'll see a section called Label Options. Uncheck Y Value and check the box for Value From Cells.
5. A dialogue box will appear prompting you to "Select Data Label Range." Click and drag to select the range in your spreadsheet that contains the product names (e.g., cell A2:A7). Click OK.
6. Your chart will now display the product names next to each bubble. You can also adjust the label position (Center, Above, Below, etc.) in the same pane to make the chart easier to read.

Step 5: Label Your Quadrants and Add Finishing Touches

The final step is to make your chart presentable by giving it context. This means adding a main chart title, labeling the axes, and most importantly, labeling the four quadrants.

To Add Axis Titles and a Chart Title:

1. Click the + button (Chart Elements) again.
2. Check the boxes for Axis Titles and Chart Title.
3. Double-click on each new text box to edit them. For our example:

To Add Quadrant Labels:

Excel doesn't have a direct feature for quadrant labels, so we'll add them manually using text boxes. This gives you full control over placement and formatting.

1. Go to the Insert tab on the ribbon.
2. Click on Text and select Text Box.
3. Click and drag to draw a text box in one of the quadrants (e.g., the top right).
4. Type the quadrant name, like "Stars." Format the text to make it stand out (bold it, change the color, etc.).
5. Repeat this process for the other three quadrants: "Question Marks" (top left), "Cash Cows" (bottom right), and "Dogs" (bottom left).

After these steps, you'll have a clear and professional matrix chart that effectively communicates your analysis.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Tips for More Effective Matrix Charts

Building the chart is one thing, making it easy to understand is another. Here are a few quick tips to elevate your charts:

• Use Color Strategically: You can right-click an individual bubble to format its color. This is great for grouping items - for example, you could make all products in the "Stars" quadrant green to signal growth and investment.
• Keep It Clean: A matrix chart is most effective when it isn't cluttered. Avoid plotting too many data points. If you have more than 15-20 items, the chart can become difficult to read. Analyze in smaller, more logical groups if possible.
• Provide Context: Always ensure your chart has a clear title and that both axes are properly labeled. Someone should be able to understand the core message of the chart without needing a detailed explanation.
• Don't Distort the Scale: Make sure the scale of your bubbles is proportional. In the Format Data Series pane under Series Options, you can adjust how the bubbles are sized (either by area or width) to ensure they accurately represent your data.

Final Thoughts

Creating a matrix chart in Excel is an incredibly useful skill. By customizing a simple scatter or bubble chart, you can build powerful strategic frameworks like the BCG matrix or Eisenhower matrix to help you and your team make better decisions. The key is to structure your data correctly and use the axis-formatting options to create your quadrants.

Manually updating Excel charts from various data sources can be time-consuming, especially when you need to pull fresh data from platforms like Google Analytics, Shopify, or your CRM. We designed Graphed to remove this friction entirely. Instead of exporting CSVs and recreating charts, you can connect your data sources once, then ask in plain English to build real-time dashboards. It's like having a data analyst on your team who handles all the manual work for you, so you can focus on the insights.