Automatically Update Graph/Chart

  • Hi,
    I have a macro that extracts data from a source workbook. The data is owerwritten every time that I use the macro. Now I have a graph that everytime I use the macro does not update with the new data, Is there a clever way to do that?


    The code for extracting from the workbook is the following:


    Robert

    .¸¸·´¯'·.¸¸.·´¯'·.¸¸·´¯'·.¸¸.·´¯'·.¸¸·´¯'·.¸¸.· ><((((º>

  • Re: Automatically Update Graph


    Hi Krishnakumar,
    That's awesome, however will this work as I delete the worksheet with data everytime I use the macro? The name of the sheet will be the same, but it will be a new sheet.


    Robert

    .¸¸·´¯'·.¸¸.·´¯'·.¸¸·´¯'·.¸¸.·´¯'·.¸¸·´¯'·.¸¸.· ><((((º>

  • Re: Automatically Update Graph/Chart


    Ok will do that, Thanks alot for your help!


    Cheers


    Robert

    .¸¸·´¯'·.¸¸.·´¯'·.¸¸·´¯'·.¸¸.·´¯'·.¸¸·´¯'·.¸¸.· ><((((º>

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!