1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Floating Graph - Excel

Discussion in 'Business Applications' started by mrwendal, Oct 16, 2003.

Thread Status:
Not open for further replies.
Advertisement
  1. mrwendal

    mrwendal Thread Starter

    Joined:
    Jul 25, 2001
    Messages:
    377
    Hi

    Does anyone know if it's possible to make a graph 'float', so that if i scroll left or right, it stays in view.

    The Freeze pane and Split options don't appear to help as the graph runs the width of the page.

    (Split gets me close, if i split the page in half lengthways, but as each split window only gets it's own vertical scroll bar and not a horizontal one too, this is no good)

    Any help would be appreciated.

    Thanks
     
  2. XL Guru

    XL Guru

    Joined:
    Aug 30, 2003
    Messages:
    2,702
    Maybe you could open a new window and arrange them horizontally, then keep the chart visible in the upper one & move around in the lower one.

    HTH,
    Andy
     
  3. mrwendal

    mrwendal Thread Starter

    Joined:
    Jul 25, 2001
    Messages:
    377
    Thanks for your advice Andy, it's one of a few workarounds that i'm having to do at the moment.

    Trouble is that other users may have to enter the sheet, and i want them to be able to scroll along to the most recent / earliest data and the graph to still be visible to them at the same time if possible.

    I'm wondering if there's some Left type property of the chart that i can use in VB to shuffle it along in relation to where the screen has been scrolled to..

    .......hmmm. where did i leave that thinking cap!
     
  4. mrwendal

    mrwendal Thread Starter

    Joined:
    Jul 25, 2001
    Messages:
    377
    With Worksheets("Sheet1")
    .ChartObjects(1).Left = .Columns("D").Left
    End With


    If i can combine this bit of code and replace Column D with the left most column that is visible whereever i scroll, i think that will be it... any ideas on how to return the left-most column identifier at all peeps?

    Thanks
     
  5. XL Guru

    XL Guru

    Joined:
    Aug 30, 2003
    Messages:
    2,702
    I can't really envisage this but I think you're quite close.

    How about something like

    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    n = ActiveCell.Column
    With Worksheets("Sheet1")
    .ChartObjects(1).Left = .Columns(n).Left
    End With
    End Sub

    in the worksheet module?

    HTH,
    Andy
     
  6. mrwendal

    mrwendal Thread Starter

    Joined:
    Jul 25, 2001
    Messages:
    377
    Thanks for the missing links Andy,

    That's the closest i'm going to get, i think, as i can't get the graph to move just by scrolling, but by changing the selected cell results in the graph moving as desired.

    Unless anyone else has any further ideas on this, i think i'm going to tinker with this and make the most of what i've got!

    Thanks Andy, et al
     
  7. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/172285

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice