how to make 3d bar graph in excel

3D Bar Graph Excel: Step-by-Step Guide

By Jessica Thomas
AD

3D bar graphs are a powerful way to visualize data in Excel, as they allow you to display data from multiple angles, making complex data sets easier to understand. Here's a step-by-step guide to help you create a 3D bar graph in Excel.

Before we diving into the steps, make sure your data is structured correctly in columns. For this example, let's assume we have three columns (A, B, and C) with headers: Category, Year 2020, and Year 2021, representing data for two consecutive years. Now, let's get started.

Creating a 2D Bar Graph

Before adding the 3D effect, let's first create a basic 2D bar graph to ensure your data is plotted correctly.

AD
How to Create a Bar Graph in Excel with 2 Variables - 3 Methods - ExcelDemy
How to Create a Bar Graph in Excel with 2 Variables - 3 Methods - ExcelDemy
Conditional Formatting in Multiple batteries Graph in Excel
Conditional Formatting in Multiple batteries Graph in Excel
How To Make a Bar Graph in Microsoft Excel 2010 - For Beginners
How To Make a Bar Graph in Microsoft Excel 2010 - For Beginners

1. **Select your data** (excluding the headers).

2. **Click on the Insert tab** in the Ribbon, then **select the Bar chart icon**.

How to Make a Simple Bar Graph in Excel (With Easy Steps) - ExcelDemy
How to Make a Simple Bar Graph in Excel (With Easy Steps) - ExcelDemy
How to Make a Simple Bar Graph in Excel (With Easy Steps) - ExcelDemy
How to Make a Simple Bar Graph in Excel (With Easy Steps) - ExcelDemy

Changing the Bar Chart Layout

After creating the bar chart, you might want to customize it to perfectly fit your data.

3. **Right-click on the chart** and select **Format Selection** (or press `CTRL+1`).

AD

4. In the **Format Selection pane**, under **Current Selection**, **click on Switch Row/Column**.

5. In the same pane, under **Axes**, **select Categories in Columns** (Tick the box).

Adding a Second Series of Data

Now, let's add the second year's data to the chart.

AD

6. **Select the chart**, click on the **Design tab**, then **Select Data**.

7. In the **Edit Series pane**, **click Add**.

8. Enter a **Series name**, **select the Category column** for X-values, and **select the Year 2021 column** for Y-values.

AD

Adding a Third Dimension to Your Bar Graph

Now that we have our 2D bar graph ready, let's add that 3D effect.

1. **Right-click on the chart** and select **Format Selection**.

2. In the **Format Selection pane**, under **Current Selection**, **scroll down toాశDepth**.

3. **Adjust the Depth value** to add a 3D effect to your bar graph. You can also rotate the chart to view it from different angles.

Congratulations! You've just created a 3D bar graph in Excel. This visual representation of your data should make it easier to identify trends, patterns, and outliers. From here, you can play around with various chart styles, colors, and layouts to make your graph even more engaging.

AD