How to Make a Matrix on Excel

Written by sarah thomas
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Make a Matrix on Excel
Use Excel to create a matrix and illustrate data. (Jupiterimages/Pixland/Getty Images)

In Excel, a matrix is a graphic that allows you to visualise relationships between different groups or items within your files. Create and use a matrix to illustrate data or subsets of data, as you would with a table or graph. A matrix consists of squares or rectangles, and you can alter the colouring, size and text within the graphic to suit your needs. Excel offers various styles and options so that you can create a customised matrix specific to your data and goal.

Skill level:
Moderately Easy


    Create the Matrix

  1. 1

    Open Excel and navigate to the "Insert" menu.

  2. 2

    Select "Illustrations" and then scroll through the options to select "SmartArt." Open the "SmartArt" option.

  3. 3

    Click on "Matrix" from the "SmartArt" gallery. Choose the layout option that best fits your needs. Options include the "Basic Matrix," a "Grid Matrix" and "Titled Matrix". The Titled Matrix allows you to emphasise the relationship between groups and the whole, while a Grid Matrix emphasises the differences between groups. A Basic Matrix does not contain a grid or title.

  4. 4

    Add text to your matrix by clicking on "[Text]" and writing in your text or pasting it from another source.

    Customise Your Matrix

  1. 1

    Navigate to "Design" and select "SmartArt Tools."

  2. 2

    Select "Change Colors" under "SmartArt Styles."

  3. 3

    Scroll through the colour list and choose the colour that you'd like. To change the colours of the borders or background, right-click on the area that you want to change and select "Format Shape" from the menu. Choose either "Line Color" or "Fill" depending on if you are changing the border or background, then select the colour from the menu.

  4. 4

    Change the look of your matrix by changing the SmartArt style. Navigate through "SmartArt Tools" and then "SmartArt styles," where you can scroll through various style options to change the appearance of your matrix.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.