Results 1 to 7 of 7

group charts and paste as picture

Threaded View

  1. #1
    Registered User
    Join Date
    07-01-2011
    Location
    canada
    MS-Off Ver
    Excel 2010
    Posts
    6

    group charts and paste as picture

    Hope you might help me in solving my problem.

    Here is what I am trying to do..:

    I have an excel sheet that has charts…

    I found a code to line up the charts in vertical order..
    Now I am trying to select each 3 chart as a group like 1 to 3, 3 to 6, 6 to 9 and paste them as picture. My knowledge on vba and coding is quite limited and thats why I am asking ur help

    It would be great if u have time to help me on this issue…
    Thanks..

    Sub LineUpMyCharts()
             Dim MyWidth As Single, MyHeight As Single
             Dim NumWide As Long
             Dim iChtIy As Long, iChtCt As Long, iChtSl As Long
             
             MyWidth = 650
             MyHeight = 180
             NumWide = 3
    
             iChtCt = ActiveSheet.ChartObjects.Count
             For iChtIy = 1 To iChtCt
                 With ActiveSheet.ChartObjects(iChtIy)
                     .Width = MyWidth
                     .Height = MyHeight
                     .Left = (iChtIy)
                     .Top = Int(iChtIy) * (MyHeight)
                 End With
             Next
    Last edited by romperstomper; 07-01-2011 at 08:30 AM. Reason: add code tags

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