Consulting

Results 1 to 3 of 3

Thread: How to position a chart?

  1. #1

    How to position a chart?

    I've created a chart but it's being popped out "at random" or at least not where i'd like it to be. I've created a macro for moving but that didn't give my much pleasure. How do i create a chart and then position it at
    a) 100x175 (just an example)
    b) exactly in the corner of cell G6 (still, just an example)

  2. #2
    VBAX Master
    Joined
    Jun 2007
    Location
    East Sussex
    Posts
    1,110
    Location
    You can use something like:
    [vba]activesheet.chartobjects(1).top = range("G6").Top[/vba]

    and then similarly for Left.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    Splendid! Thanks!

Posting Permissions

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