Insert 3D diagram in Excel
3D diagrams help to prepare complex data clearly in Excel. This practical tip shows you how to create such a graphic in Excel.
Create a three-dimensional diagram in Microsoft Excel.
As a simple example, the screenshot shows a diagram for the precipitation amount of two regions, as well as the values used for it.
- In any case, you first need the values for your diagram, if possible arranged in a table. Enter these accordingly in your Excel document.
- Now the diagram is created. To do this, click on the "Insert" tab at the top. In the middle you see a selection of possible diagram types. It is best to go to the small gray arrow at the bottom right. The "Insert diagram" window then opens.
- With the help of small images, you can select one of the many two- and three-dimensional diagram types that Excel provides.
- Click "OK" and the blank diagram will be added to your document.
- If you now click on the frame of the diagram, you will see the tab "Diagram Tools"> "Design" at the top.
- Click the "Select data" field. In this window you can now select the data and labels for the diagram from your table.
These instructions refer to Microsoft Excel 2010 under Windows 8.