How to Make a 3D Graph in Excel

Creating a 3D graph in Excel can instantly make your report or presentation look more dynamic, but getting it right can feel a little tricky. The good news is that Excel has powerful, built-in tools that make this process much more straightforward than you might think. This guide will walk you through exactly how to create, customize, and effectively use 3D graphs for your data.

Graphed

Still Building Reports Manually?

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

Watch the Demo

What Are 3D Graphs (and When Should You Use Them)?

A 3D graph adds a third dimension - depth - to a traditional 2D chart. Instead of just plotting data on an X-axis (horizontal) and a Y-axis (vertical), a 3D chart introduces a Z-axis that can represent another category or simply add visual depth. For example, a 3D column chart makes the bars look like rectangular prisms instead of flat rectangles.

While they look impressive, it's important to use them wisely. Here’s a quick breakdown of when to use them and when to stick with 2D:

• Use them for visualizing three data variables, comparing data series across multiple categories in a more engaging way, or adding visual punch to a presentation. A 3D surface chart, for example, is great for finding optimal combinations between two sets of data.
• Avoid them when precision is critical. The added perspective can sometimes make it difficult to compare values accurately. Taller columns in the front can easily obscure smaller ones in the back, distorting the story your data is trying to tell. If your audience needs to make precise comparisons, a simple 2D chart is often the better choice.

The key is to use 3D for impact and overview, not for granular, nitty-gritty analysis where small differences matter.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 1: Get Your Data Ready

Before you even click the "Insert" tab in Excel, your success depends on how you've structured your data. For most 3D charts like column, bar, or line graphs, Excel needs your data organized in a simple grid with headers defining the rows and columns.

Imagine you have quarterly sales data for different regions. Your table should look something like this:

In this structure, the "Region" column will form one axis (categories) and the "Quarters" will form another axis (data series). The dollar amounts are the values that will determine the height of your columns. A clean, simple table like this is the foundation for a great chart.

Step 2: Create Your 3D Graph in Excel

Once your data is neatly organized, creating the graph itself takes just a few clicks. We'll use the popular 3D Column chart as our main example.

How to Create a 3D Column Chart

1. Select Your Data: Click and drag your mouse to highlight the entire data set you want to visualize, including the row and column headers. In our example, you'd select the range from A1 to E5.
2. Go to the Insert Tab: Look at the ribbon at the top of Excel and click on the Insert tab.
3. Find the Charts Group: In the middle of the Insert ribbon, you’ll see the Charts group.
4. Choose the Column Chart Icon: Click on the icon that looks like a bar chart ("Insert Column or Bar Chart"). A dropdown menu will appear with different chart types.
5. Select a 3D Column Option: Hover over the options under the "3-D Column" heading. You’ll have a few choices:

For our example, a 3-D Clustered Column is a great starting point. Once you click it, Excel will instantly drop the chart into your worksheet.

Exploring Other 3D Chart Types

Excel offers more than just columns. Depending on your data, you might consider:

• 3D Pie Chart: Found under the "Insert Pie or Doughnut Chart" icon. It shows parts of a whole but with a dramatic 3D effect. Be cautious, as the perspective can make slices in the front appear larger than those in the back, even if their values are smaller.
• 3D Line Chart: Available under the "Insert Line or Area Chart" icon. It shows trends over time but displays the lines as 3D ribbons. Best used when you have very distinct data series, as the lines can easily overlap and become confusing.
• 3D Surface Chart: Click the dropdown arrow on the chart types and select "Surface." This looks like a topographical map and is perfect for finding the best combination between two sets of data, like determining the point of highest tensile strength based on combinations of time and temperature.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 3: Customize Your 3D Graph for Clarity

The default chart Excel creates is a good start, but the real magic happens in customization. A few cosmetic tweaks can turn a confusing 3D representation into a clear, compelling visual. When your chart is selected, two new contextual tabs will appear on the ribbon: Chart Design and Format.

Add Chart Titles and Axis Labels

Your chart needs context. To add or edit titles and labels:

1. Click on your chart to select it.
2. Go to the Chart Design tab.
3. On the far left, click Add Chart Element. From here, you can add or modify the Chart Title, Axis Titles (for the horizontal, vertical, and depth axes), and Data Labels (which positions the exact numeric value above each column).

Always use clear, descriptive titles. Instead of "Chart," use "Quarterly Sales Performance by Region."

Fine-Tune the 3D Rotation and Perspective

This is the most powerful customization feature for 3D charts. If a data series is hidden or the viewing angle looks awkward, you can rotate the chart to the perfect position.

1. Right-click on the Chart Area (the empty white background of the chart) and select 3-D Rotation.
2. A Format Chart Area pane will appear on the right side of your screen.
3. Under the "3-D Rotation" section, you can adjust:
4. Experiment with these values until all your data points are clearly visible and the chart looks balanced.

Change Colors and Styles

To quickly change the look and feel, use Excel’s built-in presets:

• Go to the Chart Design tab.
• The Chart Styles gallery offers a variety of professionally designed themes with different colors, backgrounds, and effects. Hover over them to see a live preview.
• Click the Change Colors button for different color palettes while keeping the same overall style.

For more specific formatting, right-click any element of the chart — like a single data series (all the blue columns, for instance), the floor, or the back wall — and select Format [Element]... to change its color, fill, or outline.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Best Practices for Using 3D graphs

• Tell a Simple Story: 3D visuals increase cognitive load. Don't try to cram too many data series or categories into one chart. If you have extremely complex data, multiple 2D charts might be better.
• Focus on Readability Above All: The #1 mistake people make is creating a chart that obscures data. Use the 3D Rotation tools to ensure that smaller columns aren't completely hidden behind larger ones. If you can't find an angle that shows all your data clearly, that's a sign that a 2D chart is the better option.
• Check Your Perspective: Be mindful that perspective can distort perception. What looks bigger might not actually be the largest value. Consider adding Data Labels to show the exact values and remove any ambiguity.
• Know Your Audience's Goal: Are you trying to impress or inform? For a high-level executive summary or a marketing pitch, a visually striking 3D graph can work wonders. For an analytical team that needs to make precise decisions based on the data, a 2D chart’s simplicity and accuracy will always win.

Final Thoughts

With a bit of practice, you can easily create and format professional-looking 3D graphs in Excel. Remember to start with well-structured data, choose the right chart type for your story, and prioritize readability by carefully adjusting the 3D rotation and perspective to ensure your visualization is as clear as it is eye-catching.

Manually creating charts like this in Excel is one thing, but if you're regularly pulling data from different places like Google Analytics, Shopify, and various ad platforms, the process of data prep and reporting can quickly become a full-time job. With Graphed you can connect directly to your marketing and sales data sources. This allows you to build live, interactive dashboards simply by describing what you want to see — no more spending hours exporting CSVs and fiddling with settings. It takes seconds to ask a question and get a visual answer, giving you back time to focus on strategy instead of report-building.