Seeing things in two dimensions can bore you to death at times. A little bit of graphics take the same thing and turns it into a beautiful sight for your sore eyes. We are going to carry out one such thing moving forward. This article is dedicated to demonstrating the construction of a 3D Bar Chart in MS Excel. Are any cricket fans reading this? So, how about we put some data from cricket & transform it into one?
Following is the data set that we shall use throughout this article.
![How to Create 3D Bar Charts in Excel? 3 Runs Scored](https://quickexcel.com/wp-content/uploads/2022/10/Runs-Scored.jpg)
For those who don’t fancy cricket – the above data are the points scored by different players in different formats of the game. Enough of explaining the data & let’s get to the good stuff!
Also read: How to Create 3D Column Charts in Excel?
Steps to Create 3D Bar Charts in Excel
One shall get things started by selecting the data for which the 3D bar chart is to be created & getting into the Insert tab among the list of available tabs as shown below.
![How to Create 3D Bar Charts in Excel? 4 Locating Insert Tab 4](https://quickexcel.com/wp-content/uploads/2022/10/Locating-Insert-Tab-4.jpg)
Once within the Insert tab, get into the Charts section & click on the icon for Bar Charts as indicated below.
![How to Create 3D Bar Charts in Excel? 5 Selecting Bar Chart](https://quickexcel.com/wp-content/uploads/2022/10/Selecting-Bar-Chart.jpg)
Now there shall be a drop-down menu appearing as indicated with the different variants in bar charts. All eyes on the 3D bar section please select the icon of the 3D Stacked Bar Chart as indicated (The following procedure remains the same for the other types of 3D Bar Charts too).
![How to Create 3D Bar Charts in Excel? 6 Selecting 3D Bar Chart](https://quickexcel.com/wp-content/uploads/2022/10/Selecting-3D-Bar-Chart.jpg)
Since the data has already been selected the 3D Stacked Bar Chart now appears before your eyes!
![How to Create 3D Bar Charts in Excel? 7 Chart Appears](https://quickexcel.com/wp-content/uploads/2022/10/Chart-Appears.jpg)
But something is fishy, ain’t it? The Chart Title & the Legend section are filled with the default values. So, let us change these, one by one. First off, let us attack the Chart Title section by double-clicking on it, & replacing the default values with the title of our choice.
![How to Create 3D Bar Charts in Excel? 8 Chart Title Changed](https://quickexcel.com/wp-content/uploads/2022/10/Chart-Title-Changed.jpg)
Now time to change the Legend by right-clicking anywhere within the chart area & choose the Select Data option as shown below.
![How to Create 3D Bar Charts in Excel? 9 Choosing Select Data 1](https://quickexcel.com/wp-content/uploads/2022/10/Choosing-Select-Data-1.jpg)
Now the Select Data Source pop-up appears. Get into the Legend Entries section, select the Series1 option & then click on the Edit option.
![How to Create 3D Bar Charts in Excel? 10 Editing Series1 Name](https://quickexcel.com/wp-content/uploads/2022/10/Editing-Series1-Name.jpg)
The Edit Series dialog box appears now & one can either type the name for Series1 or give a reference to the cell which contains it. We shall adopt the latter approach as indicated in the image below. Click OK once done.
![How to Create 3D Bar Charts in Excel? 11 Cell Reference](https://quickexcel.com/wp-content/uploads/2022/10/Cell-Reference.jpg)
One can now see that the name of the series has been changed to Test as depicted below.
![How to Create 3D Bar Charts in Excel? 12 Series1 Name Changed](https://quickexcel.com/wp-content/uploads/2022/10/Series1-Name-Changed.jpg)
Follow the same procedure to change the name of Series2 too & then click OK in the Select Data Source dialog box.
![How to Create 3D Bar Charts in Excel? 13 Both Series Name Changed](https://quickexcel.com/wp-content/uploads/2022/10/Both-Series-Name-Changed.jpg)
The updated chart reveals itself the very moment OK is clicked with much more clarity & ease to be comprehensible now.
![How to Create 3D Bar Charts in Excel? 14 Legend Updated](https://quickexcel.com/wp-content/uploads/2022/10/Legend-Updated.jpg)
Well, it’s great that we can get this far but, what if one wants to change the orientation of this three-dimensional bar chart a tad bit in any direction of choice?
Modifying Chart Orientation:
![How to Create 3D Bar Charts in Excel? 15 Selecting Format Chart Area](https://quickexcel.com/wp-content/uploads/2022/10/Selecting-Format-Chart-Area.jpg)
Right-click anywhere within the chart & choose the Format Chart Area option. A pallet appears on the right side of the screen. Choose 3D Rotation within that & change the X-Y rotation as required.
![How to Create 3D Bar Charts in Excel? 16 X Y Rotation](https://quickexcel.com/wp-content/uploads/2022/10/X-Y-Rotation.jpg)
![How to Create 3D Bar Charts in Excel? 17 Chart Oriented](https://quickexcel.com/wp-content/uploads/2022/10/Chart-Oriented.jpg)
Conclusion
Have a look at this article, in case you would like to know about creating 2D Bar Charts in MS Excel. There are numerous equally interesting & informative articles in QuickExcel that serve to be a great help to those who pursue their journey to excel in MS Excel. Hope this article helped you understand how to create a 3D Bar Chart in MS Excel & has given you what you came looking for! Cheers.