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

Last reviewed: November 30, 1994
Article ID: Q89649
The information in this article applies to:
  • Microsoft Excel for Windows, versions 4.0, 4.0a, 5.0
  • Microsoft Excel for the Macintosh, versions 4.0, 5.0

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. Choose 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. Choose the OK button.

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


KBCategory: kbusage
KBSubcategory:

Additional reference words: 4.00 small shrink 3D 5.00


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 30, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.