Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Charts > Formatting - 3D< Previous | Next > 

 

Creating 3D Charts

 
 

It is possible to create 3D charts in Excel.

 
 

Not all 3D charts have to actually have a third dimension (and have a third axis).

 
 

3D charts will often have three axes corresponding to the height, width and depth of the chart.

 


 

3D Bar Chart

 
   
 

You can also select (Chart > 3D View) to display the 3D view dialog box.

 
 

You can change the rotation of the charts as well as the elevation and perspective

 

 

Rotating Charts

 
 

When a 3D chart is active you can select (Chart > 3D View) to display the 3D View dialog box

 
 

 (View > 3D View) dialog box

 
 

The sample chart displayed in the dialog box shows the result of the current settings.

 

   

 

Things to Remember

 
 
  • Excel does not support 3D combination charts.

     
     
  • The maxiumum number of data points on a 3D chart is 4,000.

     

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.< Previous | Top | Next >