+ Reply to Thread
Results 1 to 2 of 2

Macro for automatic updation of chart

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Excel 2003

    Macro for automatic updation of chart

    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
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast

    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.


+ 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


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