Microsoft KB Archive/931390

= A hidden series in an Excel 2003 chart does not appear in the chart legend after you unhide the series in Excel 2007 =

Article ID: 931390

Article Last Modified on 10/15/2007

-

APPLIES TO


 * Microsoft Office Excel 2007

-



SYMPTOMS
You open a Microsoft Office Excel 2003 workbook in Microsoft Office Excel 2007. If the workbook contains a chart that has a hidden series, one or more of the following symptoms occur after you unhide the hidden series:
 * The hidden series does not appear in the chart legend.
 * The hidden series is missing a border in the chart.
 * One or more than one series that were not hidden do not appear in the chart legend.



WORKAROUND
To work around this problem, follow these steps in Excel 2007:  Re-create the chart legend. To do this, follow these steps:  Click to select the chart. In Chart Tools, click the Layout tab, click Legend, and then click Show Legend at Right.

Note The series appears in the legend.

Note You can select a different option in order to display the legend in a different position on the chart. For example, to display the legend on the left, click Legend, and then click Show Legend at Left.  Set the border for the series. To do this, follow these steps:  Click to select the series. In Chart Tools, click to select the Layout tab, and then click Format Selection.</li> Click Border Color, click Solid Line, and then click Close.

Note A border appears around the series.</li></ol> </li></ol>

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

Keywords: kbtshoot kb32bitonly kbprb kbexpertisebeginner KB931390

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.