+ Reply to Thread
Results 1 to 6 of 6

Excel 2007 : Copy chart, change data source

  1. #1
    Registered User
    Join Date
    01-18-2011
    Location
    Greece, Thessaloniki
    MS-Off Ver
    Excel 2003
    Posts
    11

    Copy chart, change data source

    Hello,
    I have some values, and a chart next to them.
    I want to copy this "box" 100 times, but i want every chart to be linked
    to the values next to it. The problem is that excel will link all this charts with
    the values of the first "box".

    I attached an example.

    Thank you.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    01-18-2011
    Location
    Greece, Thessaloniki
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Copy chart, change data source

    seriously...
    noone?

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,547

    Re: Copy chart, change data source

    try this,

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  4. #4
    Registered User
    Join Date
    01-18-2011
    Location
    Greece, Thessaloniki
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Copy chart, change data source

    Thank you for your answer but it doesn't help me.
    Maybe i do something wrong. Can you make my example file work and upload it?
    And something else, i don't know much about coding, but it seems that your code has to do with
    those 2 particular "boxes", i want to copy this 100 times, so i need a code that refers to any copy of this box i may do.
    Thank you.

  5. #5
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,547

    Re: Copy chart, change data source

    For the sake of example my code only does 3 copies but in order to do 100 you simply change the upper parameter of the For loop.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    01-18-2011
    Location
    Greece, Thessaloniki
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Copy chart, change data source

    It worked!

    Thanks a lot Andy ! !

+ 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