+ Reply to Thread
Results 1 to 6 of 6

Fixing graph in relation to the worksheet

  1. #1
    Registered User
    Join Date
    11-23-2012
    Location
    Maldives
    MS-Off Ver
    Excel 2007
    Posts
    24

    Fixing graph in relation to the worksheet

    When it is scrolled, graph moves with the scrolling. Is there anything that can be done to make the graph stationary unless it is moved. - No freezepan, because it occupies a large space on the worksheet.

  2. #2
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Fixing graph in relation to the worksheet

    Try adapting the code in this thread

    Or you could right-click the chart border, choose Format Chart Area, select Properties in the left pane, then choose the option of Don't move or size with cells
    Palmetto

    Do you know . . . ?

    You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.

  3. #3
    Registered User
    Join Date
    11-23-2012
    Location
    Maldives
    MS-Off Ver
    Excel 2007
    Posts
    24

    Re: Fixing graph in relation to the worksheet

    @ Palmetto Updating the code did not work. And there is no Properties in the left pane in Format Chart Area

  4. #4
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Fixing graph in relation to the worksheet

    All versions of Excel, as far as I know, have a Chart properties dialogue.
    Your profile shows Excel 2007, so you should have access to this property.
    Select Chart > Chart Tab > Layout > pick Chart Area from drop down (upper left of Ribbon) > then click Format Selection.
    Properties is displayed in the dialog near the bottom of the list.

    However, setting the option to not move or resize with cell doesn't solve your scrolling issue - but it does prevent the size from being changed if you resize or move cells.

    That bit of code works fine for me, without any changes, though the chart (in testing) is not displayed where I would have it.
    The code must be placed in the module of the sheet containing the chart. You will have to make adjustments to the width value to get it to display where you want it.

    If that doesn't work for you, the only other option is to use Freeze Panes.

  5. #5
    Registered User
    Join Date
    11-23-2012
    Location
    Maldives
    MS-Off Ver
    Excel 2007
    Posts
    24

    Re: Fixing graph in relation to the worksheet

    Picture attached. It shows that I don't have Properties in Format Selection.

    The code does prevent the size from being changed if resized or cells are moved. But it still doesn't solve my problem.
    Attached Images Attached Images

  6. #6
    Registered User
    Join Date
    11-23-2012
    Location
    Maldives
    MS-Off Ver
    Excel 2007
    Posts
    24

    Re: Fixing graph in relation to the worksheet

    So, it is not possible ?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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