Results 1 to 6 of 6

Thread: Dynamically Update Chart With Latest X Columns Of Data As New Data Is Updated

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #2
    Junior Member
    Join Date
    Sep 2011
    Posts
    9
    Rep Power
    0
    Would this work?

    If I used "offset" to define my chart data range and delete the reference column each week, containing data to the left of my range that I no longer need.

    Would the range advance and update automatically, given that is is defined by the number of columns to the right of the reference cell?
    Last edited by Admin; 07-21-2014 at 07:32 AM.

Similar Threads

  1. Replies: 6
    Last Post: 04-08-2014, 05:34 PM
  2. Replies: 10
    Last Post: 02-18-2014, 01:34 PM
  3. Compare Date Columns In Excel And Pull The Latest Date
    By marentette010 in forum Excel Help
    Replies: 1
    Last Post: 07-31-2013, 11:56 PM
  4. Update All Tables With Newly Added Data
    By redja71 in forum Access Help
    Replies: 5
    Last Post: 07-16-2013, 07:06 AM
  5. Moving Current Latest Data To New Workbook
    By Terry in forum Excel Help
    Replies: 1
    Last Post: 01-19-2013, 12:37 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •