Excel: Preferred Chart Format Doesn't Save Legend PositionLast reviewed: November 29, 1994Article ID: Q88748 |
The information in this article applies to:
SYMPTOMSIn 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.
STATUSThis functionality exists in later versions of Microsoft Excel for Windows.
MORE INFORMATIONExcel 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.
WORKAROUNDTo 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:
To create a new chart from your template:
REFERENCES"Microsoft Excel User's Guide 1," version 4.0, pages 81-83, 400, 421-422
|
KBCategory: kbusage
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |