How to Make a Matrix Logic Chart

Display information for your matrix logic chart using Microsoft Excel.

Matrix logic charts are used to summarize two or more data sets in a grid, such as products, countries, year, or other sets. At least two text columns with values are needed to make a matrix logic chart. If you do not want to make a chart manually, you can use database software to enter the values needed for the chart, and use the "chart" function to make the matrix logic chart.

Instructions

1. Open Microsoft Excel on your computer. Click on the "File" tab on the top toolbar. Select the "Blank Workbook" option and click on the "Create" button.

2. Click on an empty cell and enter a title in one column. For example, enter "Cooking Utensils" in the empty cell. Press the "Enter" key.

3. Click on the empty cells below the title and type the information. Press the "Enter" key and Excel automatically shifts to the cell below. For example, enter "Spoon" or "Knife" in the cells underneath the title. Type one value in each cell.

4. Click on the empty cell adjacent to the title cell. Enter the second title in an empty cell in the adjacent column. For example, enter "Cost" in the empty cell. Press the "Enter" key.

5. Click on the empty cells below the title and type the information. Press the "Enter" key and Excel automatically shifts to the cell below. For example, enter "5" or "3" in the cells underneath the title. Type one value in each cell.

6. Highlight the matrix information. Click on the first cell and hold down the mouse. Move the mouse until all the cells are highlighted and release the mouse button.

7. Click on the "Insert" tab on the top toolbar. Click on the "Pie" option in the "Charts" section and select the Pie chart you want. Excel automatically creates the matrix logic chart and it appears on your screen.

Tips & Warnings

• Add additional columns as needed for your matrix.

References

• IBM: Matrix Chart Guide

Resources

• Andy Pope: Spotlight Chart