vba - Automatically update graph - Excel -


I'm trying to create an update graph automatically. This is what I want to do:

I am updating my data every day. So we say that I have 3000. I think the date associated with that number needs today's date.

Then on 27-10 - 3000. And I want to add data every day. So 3010 is 28-10. e.t.c. e.t.c.

But I want to do it automatically Each day the graph automatically adds new data to the current date.

I am unfamiliar with the graph and there is no clue how to do this. The only thing I know is that task (TODAY) and that the data is always in a cell: I8.

Any help is greatly appreciated :)

Create a dynamic naming category for your data (using OFFSET To dynamically include all the new values, div category = "post-text" itemprop = "text" example:

  • Create a pivot table based on that data

    • Ol>

    down A. See Example: 

      ActiveSheet.PivotTables ( "PivotTable1"). PivotCache.Refresh

    You can add this macro to an ActiveSheet change event or to add a button to refresh the better chart.


    Comments

    Post a Comment