Microsoft KB Archive/931391

= The page orientation for a chart may change when you move the chart onto a sheet in Microsoft Office Excel 2007 =

Article ID: 931391

Article Last Modified on 10/15/2007

-

APPLIES TO


 * Microsoft Office Excel 2007

-



SYMPTOMS
When you move a chart onto a sheet in a Microsoft Office Excel 2007 workbook, the page orientation for the chart may change.

For example, consider the following scenario:
 * You create a chart in an Excel 2007 workbook.
 * You set the page orientation for the chart sheet to portrait orientation.
 * You move the chart to a different sheet in the workbook.

In this scenario, the page orientation for the chart may be set to landscape orientation.



CAUSE
This problem occurs because Excel 2007 does not maintain the page orientation when you move the chart.



RESOLUTION
To work around this problem, set the page orientation for the chart to portrait orientation after you move the chart. To do this, follow these steps:
 * 1) Click the chart, and then click the Page Layout tab.
 * 2) Click Orientation, and then click Portrait.



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



Steps to reproduce this problem

 * 1) Start Excel 2007.
 * 2) Type 1 in cell A1, and then press F1.

Note A new chart is created, and the Chart1 sheet is displayed.
 * 1) On the Page Layout tab, click Orientation, and then click Portrait.
 * 2) In Chart Tools, click the Design tab, click Move Chart, click Object in, and then click OK.

Note The chart that is in the Chart1 sheet moves onto the Sheet1 sheet. Also, the Chart1 sheet is removed, and the Sheet1 sheet is displayed.
 * 1) Click the chart that was moved, click the Microsoft Office Button, point to Print, and then click Print Preview.

Note The page orientation for the chart is set to landscape orientation.

Keywords: kbtshoot kbprb kbexpertisebeginner KB931391

-

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

© Microsoft Corporation. All rights reserved.