+ Reply to Thread
Results 1 to 1 of 1

copy chart to the right

  1. #1
    Registered User
    Join Date
    05-30-2006
    Posts
    6

    copy chart to the right

    Hi people!

    i have some rows of data and i whant to make 1 chart per section of data.

    the "sectios" are 100rows x 5columns.


    i have a problem with my script:

    this is the part i recorded as makro:

    ActiveChart.SetSourceData Source:=Sheets("alle vergleiche_Export gesamt"). _
    Range("A102,N102:R102,A104:A486,N104:R486"), PlotBy:=xlColumns

    the problem i have is how to let the columns "grow" in a loop?

    i tryied to use cells within Range(), but i don't get it to work. Then i tryied to use a simple string in Range(myString), and define myString like this:

    myString = "A102," & MyColumn1 & "102:" & MyColumn2 & "102 , A104: A486 ," & MyColumn1 & "104:" & MyColumn2 & "486 "
    how can i let MyColumn1 and MyColumn2 grow each loop? this variables are strings, containing a character (or 2, as soon as i get over z to aa ab,...)

    how can i make MyColumn1 = MyColumn1 + 5????

    thank you very much!!!
    Last edited by leg; 10-12-2007 at 03:06 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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