Results 1 to 6 of 6

dynamic chart update

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-27-2019
    Location
    europa
    MS-Off Ver
    excel 2007
    Posts
    479

    dynamic chart update

    Hello to all.
    in the attached chart I inserted in define name this formule:

    commessa	        =OFFSET(FORMULA!$B$9,,,COUNTIF(FORMULA!$B$9:$B$28,"<>"))			
    percentuale	=OFFSET(FORMULA!$F$9,,,COUNTIF(FORMULA!$F$9:$F$28,"<>"))
    I don't understand where I'm wrong, the chart doesn't update
    adding or removing values
    xam
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Update Chart data in dynamic range
    By soidog in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-04-2019, 08:07 AM
  2. Automatic update dynamic chart for last n weeks.
    By mikkisbee in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-26-2017, 02:51 AM
  3. Macro to update chart using dynamic named range
    By VBAClueless in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-11-2016, 07:03 AM
  4. [SOLVED] Dynamic chart title created in VBA does not auto-update
    By DH112213 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-22-2013, 12:38 PM
  5. [SOLVED] Chart date labels don't update (using dynamic named range)
    By s80NL in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-04-2013, 11:35 AM
  6. Dynamic chart update
    By jansie in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-07-2010, 01:58 PM
  7. Dynamic range to update chart, multiple series
    By staples in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 07-31-2009, 12:26 PM

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