Excel: 3-D Chart Created in 3.0 Smaller when Opened

ID: Q89649

The information in this article applies to:

SUMMARY

If you are using Microsoft Excel versions 4.0 and later, and you open a 3-D chart that was created in Microsoft Excel version 3.0, the chart may appear smaller that than it did in Microsoft Excel version 3.0.

In Microsoft Excel version 3.0, charts are automatically scaled to fit the chart window -- there is no option to control this scaling. However, in Microsoft Excel version 4.0 and later, you have the option to control this scaling. Since this option is not available in Microsoft Excel version 3.0, when you open a chart created in Microsoft Excel 3.0 in later versions, the chart will be opened without this option enabled, and it will appear smaller it did in Microsoft Excel version 3.0.


MORE INFORMATION

In Microsoft Excel versions 4.0 and later, if the Auto Scaling check box (located in the 3-D View dialog box) is selected, your chart will be scaled to fill the chart window. When you disable this option, the x-axis and the y-axis will be the same size. This results in the chart appearing smaller than scaled charts.

In Microsoft Excel versions 3.0, 4.0, and later, you can format 3-D charts with the options that are available in the 3-D View dialog box. You can use these options to display your chart in a right angle axes view or a in customized perspective angle view.

In Microsoft Excel version 3.0, both of these view angles are scaled to fit the chart window. However, in Microsoft Excel versions 4.0 and later, the Auto Scaling option is only available when your chart is in a right angle axes view. If you customized the perspective angle of your chart, use the Height % Of Base box to change how your chart fills the chart window.

To make your chart fill the chart window, use the appropriate method below (depending on the view angle of your chart).

Right Angle Axes View

If your chart is displayed in a right angle axes view, you can make your chart fill the entire chart window by enabling the Auto Scaling option in the 3-D View dialog box:

  1. If the chart is a chart object on your worksheet, double-click the chart to bring it into a separate chart window.


  2. From the Format menu, choose 3-D View.


  3. Select the Auto Scaling check box.


  4. Click OK.


Perspective View

If you chart is set to a customized angle, you can make your chart fill the chart window by adjusting the number in the Height % Of Base box (the lower the value, the shorter and wider your chart will be):

  1. If the chart is a chart object on your worksheet, double-click the chart to bring it into a separate chart window.


  2. From the Format menu, choose 3-D View.


  3. Enter a value lower than 100 in the Height % Of Base box.


  4. Click OK.


NOTE: You may have to experiment with the value in the Height % Of Base box to achieve the desired scale.


REFERENCES

"User's Guide 1," version 4.0, pages 489-490

Additional query words: small shrink 3D \* \* w_excel 


Keywords          : 
Version           : WINDOWS:4.0,4.0a,5.0; MACINTOSH:4.0,5.0
Platform          : 
Issue type        :

Last Reviewed: March 26, 1999