+ Reply to Thread
Results 1 to 2 of 2

Macro for automatic updation of chart

  1. #1
    Registered User
    Join Date
    09-25-2010
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    1

    Macro for automatic updation of chart

    Hi
    I need to generate monthly charts. There are 14 chart in my sheet. I need to write a macro so that all those graph are automatically updated with new month's data. For that the macro should:

    Select the graph sequentially. (one after other)
    Select the data
    Add one more row(data of month)
    update the graph

    I tried different ways but

    anyone any suggestion

  2. #2
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,364

    Re: Macro for automatic updation of chart

    I tried different ways but
    That's not enough information to help you. You need to post a sample file with your data structure and charts.

    How are we supposed to guess where your data is and what the charts are supposed to look like?

    You may probably use the techniques described in http://peltiertech.com/Excel/Charts/Dynamics.html , but to help you further, please provide a data sample in a workbook and include some charts.

    cheers

+ Reply to Thread

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