How to Make 3D Table in Excel (2 Suitable Ways)

Microsoft Excel is the leading spreadsheet application for numerous reasons. You can get many surprising outputs from Excel only if you can use it right. You can even create a 3D table in Excel although we use it for 2D datasets most of the time. In this article, we will highlight how to make a 3D table in Excel. Follow along!


Download Practice Workbook

You can download the practice workbook from the download button below.


2 Ways to Make a 3D Table in Excel

Here we will highlight 2 possible ways to make a 3D table in Excel. The first one is to make a 3D table from a 3D dataset. And the rest one is preparing such a table from a 2D dataset in Excel. So, let’s start!


1. Make a 3D Table with a 3D Dataset

In this method, we will highlight how to make a 3D table using a dataset with 3 variables. Follow the steps below to be able to do that.

  • Suppose you have the following dummy dataset containing 3 tables. The tables are interconnected through the 3 variables: product_company, year, and region. The rows and columns of the tables are formatted in such a way that they can be perceived as the sides of a 3D table.

dataset to make 3D table

Important! Note that the regions are in reverse order between the tables.

  • Now, copy the first table without the headers and paste it as Linked Picture (I).

copy table and paste as Linked Picture

  • Then drag the picture to an empty space. Select the picture and go to Picture Format >> Picture Effects >> 3D-Rotation >> Parallel >> Isometric: Left Down.

add picture effects for 3D table

  • Next, copy the second table with headers and paste it as Linked Picture (I). Then drag it above the first picture. Now select it and go to Picture Format >> Picture Effects >> 3D-Rotation >> Parallel >> Isometric: Bottom Down.

copy the second table as Linked Picture

  • Now drag and align these two pictures as follows.

allign pictures to make 3D table

  • Then, copy the third table without the header rows and columns and paste it as Linked Picture (I). Now select it and go to Picture Format >> Picture Effects >> 3D-Rotation >> Parallel >> Isometric: Right Up. Then align this picture with the other two.

copy third table as Linked Picture

  • Next, hold CTRL and select all three images, right-click, and select Group.

group the tables

  • As a result, you will get the following 3D table.

3D Table in Excel

Read More: How to Create a Table in Excel with Multiple Columns


2. Create a 3D Table with a 2D Dataset

You can also create a simple 3D table using a 2D dataset. Consider the following table with 2 variables.

2D dataset for 3D table

  • First copy the entire table including the headers and paste it as Linked Picture (I). Then, select it and go to Picture Format >> Picture Effects >> Preset >> Preset 9.

apply preset to Linked Picture

  • As a result, you will get the following 3D table.

3D table using 2D dataset

Read More: Create Table in Excel Using Shortcut (8 Methods)


Things to Remember

  • Notice carefully how the data tables are arranged. Don’t forget to reverse the headers when needed. Otherwise, the data in the 3D table won’t match the data in the actual data tables.
  • If you change the data in the dataset tables, the 3D table will update automatically.

Conclusion

Now you know how to make a 3D table in Excel. Do you have any further queries or suggestions? Please let us know in the comment section below. You can also visit our ExcelDemy to explore more about Excel. Stay with us and keep learning.


Related Articles

Md. Shamim Reza

Md. Shamim Reza

Hello there! This is Md. Shamim Reza. Working as an Excel & VBA Content Developer at ExcelDemy. We try to find simple & easy solutions to the problems that Excel users face every day. Our goal is to gather knowledge, find innovative solutions through them and make those solutions available for everybody. Stay with us & keep learning.

We will be happy to hear your thoughts

Leave a reply

5 Excel Hacks You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS

ExcelDemy
Logo