+ Reply to Thread
Results 1 to 4 of 4

Excel automatically changes charts from landscape to portrait view

  1. #1
    Registered User
    Join Date
    05-03-2012
    Location
    New Jersey
    MS-Off Ver
    Office 365
    Posts
    2

    Excel automatically changes charts from landscape to portrait view

    I have a number of charts that have their own location (not within a worksheet) and for some reason they have reverted to a portrait orientation even though I created and saved them in landscape orientation. When checking page layout orientation, it is greyed out and landscape is still selected. Some other times when the orientation automatically changes to portrait, I check the orientation and it is no longer greyed out yet landscape is still selected; I'm able to fix the chart by selecting portrait view and then landscape view again, after which the chart returns to normal. After closing and reopening the file, the charts revert back to landscape mode. I find it most annoying having to close and reopening files or constantly having to perform the page orientation switch because the charts keep changing orientation automatically.

    Has anyone experienced this or can anyone offer any suggestions? I'm running windows 8 with Office 365.

  2. #2
    Registered User
    Join Date
    05-03-2012
    Location
    New Jersey
    MS-Off Ver
    Office 365
    Posts
    2

    Re: Excel automatically changes charts from landscape to portrait view


  3. #3
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: Excel automatically changes charts from landscape to portrait view

    Is it importing settings from your default printer maybe?
    Click the [* Add Reputation] Button to thank people for help!
    Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
    Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.

  4. #4
    Registered User
    Join Date
    07-01-2013
    Location
    Bear, DE, USA
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: Excel automatically changes charts from landscape to portrait view

    I encountered this issue back in 2014 for the first time. It occurred in a virtual environment (VDI session) when you would time out of the session. Upon re-entering, all chart pages had changed their orientation from Landscape to Portrait. The option to change the page orientation would be unavailable (grayed out), so the only recourse was to close and reopen. If there were unsaved changes, they would be lost.

    To help remedy the situation, I wrote a macro that changes all chart sheets (in the selected workbook) from Portrait to Landscape orientation. It's not a solution, or even an explanation as to why the orientation changes, but it can help, if you have unsaved changes that you'd rather not lose.

    Here is the code:
    Sub SetChartsLandscape()
    '******************************************************************************
    '* This macro loops thru all "chart sheets" in a workbook, and sets the
    '* page orientation from portrait to landscape.
    '******************************************************************************
    Dim i As Integer
    Dim Msg3 As String, Resp3 As String
    Const MacroName As String = "SetChartsLandscape"
    '* verify before starting
    Msg3 = "Do you wish to set all chart sheets to landscape orientation? "
    Resp3 = MsgBox(Msg3, vbYesNo + vbQuestion, MacroName)
    If Resp3 = vbNo Then Exit Sub
    With Application
    .ScreenUpdating = False
    .PrintCommunication = False
    For i = 1 To Sheets.Count
    If Sheets(i).Type = 3 Then
    With ActiveChart.PageSetup
    If .Orientation = xlPortrait Then .Orientation = xlLandscape
    End With
    End If
    Next i
    .ScreenUpdating = True
    .PrintCommunication = True
    End With
    MsgBox "Process Complete. ", vbOKOnly, MacroName
    End Sub

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Portrait & Landscape on the same tab
    By stemcell1 in forum Excel General
    Replies: 3
    Last Post: 08-23-2016, 09:18 AM
  2. Replies: 0
    Last Post: 02-17-2015, 06:58 AM
  3. Excel won't print file if Landscape, only portrait?
    By ibabs in forum Excel General
    Replies: 0
    Last Post: 07-24-2013, 12:40 PM
  4. Replies: 0
    Last Post: 07-12-2012, 09:05 AM
  5. Replies: 12
    Last Post: 08-11-2010, 04:54 PM
  6. portrait vs. landscape
    By jdnstef in forum Excel General
    Replies: 6
    Last Post: 10-27-2006, 04:05 AM
  7. Print both Portrait and Landscape - Excel
    By Georgie77 in forum Excel General
    Replies: 8
    Last Post: 05-31-2005, 08:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1