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.
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.
- Click Border Color, click Solid Line, and then click Close.
Note A border appears around the series.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.