Excel: Preferred Chart Format Doesn't Save Legend Position

Last reviewed: November 29, 1994
Article ID: Q88748
The information in this article applies to:
  • Microsoft Excel for Windows, versions 4.0, 4.0a

SYMPTOMS

In the versions of Microsoft Excel for Windows listed above, the position of a legend within a chart is not saved with the preferred chart format.

The chart legend on a new chart is positioned to the right of the chart, regardless of where the legend was positioned when you set the preferred chart format.

STATUS

This functionality exists in later versions of Microsoft Excel for Windows.

MORE INFORMATION

Excel applies the preferred chart format to new charts you create. You can change the preferred chart format to match the formatting of the active chart document by choosing Set Preferred from the Chart menu. However, version 4.0 of Excel for Windows doesn't save the legend position with the preferred chart format.

WORKAROUND

To save the legend position along with your other preferred chart format, create a chart with the formatting you want and save it as a chart template.

To create a chart template:

  1. Create a chart in Excel and format it the way you want your preferred chart format to look, including the position of the legend.

  2. From the File menu, choose Save As.

  3. In the Save As dialog box, select the XLSTART directory in the directory list.

    Note: If you save a template in the XLSTART directory, Excel shows it as a new document type when you choose New from the File menu.

  4. Enter the name you want for your preferred chart format template in the File Name box.

  5. In the Save As dialog box, select Template from the Save File as Type list.

  6. Choose OK.

Excel saves your template in the XLSTART directory.

To create a new chart from your template:

  1. Select the cells containing the data you want to plot.

  2. From the File menu, choose New.

  3. In the New dialog box, select your chart template name from the New list.

  4. Choose OK.

Excel creates a new chart using the data you have selected and the format and chart type from your template.

REFERENCES

"Microsoft Excel User's Guide 1," version 4.0, pages 81-83, 400, 421-422


KBCategory: kbusage
KBSubcategory:

Additional reference words: 4.0 4.00 graph wrong place


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 29, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.