How to Create a 3D Chart in Excel. Any chart that has been created in Microsoft Excel 2007 can be turned into a 3D chart. This process allows you to specify the type of bevel, depth, contour and surface of the 3D effect you apply to the chart. Follow the steps below to find out how you can create a 3D chart in Excel.
Start Microsoft Excel 2007 and open an existing workbook that contains a chart that you would like to turn into a 3D chart or create a new chart from existing data in a workbook.
Click in a blank area of the chart you want to turn into a 3D chart so the whole chart is selected. You can tell the whole chart is selected because it will be surrounded by a light blue outline.
Choose the "Format" tab at the top of the Excel screen to display the formatting options for the selected chart. Locate the "Shape Styles" section of the "Format" ribbon.
Toggle the small button that is depicted by half a square and an arrow on the right side of the "Shape Styles" title bar. This will bring up the "Format Chart Area" dialog box.
Select "3-D Format" from the category list on the left side of the "Format Chart Area" dialog box to display the formatting options for creating a 3D chart in Excel.
Set a top and bottom bevel style for the chart including the width and height of each bevel in the "Bevel" section of the "Format Chart Area" dialog box. Select the color and size of depth and contour in the "Depth" and "Contour" sections. Choose the type of material, type of lighting and angle of lighting in the "Surface" section of the dialog box.
Use the "Close" button to close the "Format Chart Area" dialog box and return to your chart. You will see that the chart is now a 3D chart designed to your specifications.