+ Reply to Thread
Results 1 to 2 of 2

Excel charts data auto range / batch update ?

  1. #1
    Registered User
    Join Date
    05-18-2005
    Posts
    3

    Question Excel charts data auto range / batch update ?

    Hello Excel experts !
    Could anyone please help me to find out if there is a way in Excel (currently using 2000 version but it would be useful to know if any of this issues solved in next versions...) to solve my problem:
    I've got excel file that I am using as template. File format looks something like
    excel table, 4 excel X-Y Charts based on data in that table (different colums cross-posted), another excel table, another 4 excel X-Y charts e.t.c. plus at the end there are 4 Charts based on all excel tables in that file.
    When I use that file as a template - data that I have to put this excel tables does not have constant length i.e. in one case table got values from 5 to 400 (A5-A400, B5-B400 e.t.c.) and in other 5 to 600 e.t.c.
    So after all this tables updated I have to edit "Series" definitions in Charts to update range of data that have to be plotted and as you coudl see that is quite a job... (each chart refer to 4 columns).
    I would like to find out if there is any software, tool, script e.t.c. that allow me just to extract this info and update it in batch - i.e. all entries in file like "=DataTB1!$D$7:$D$383" to be updated to "=DataTB1!$D$7:$D$640" e.t.c. ?

    Or if that is not possible - is there any way to define such ranges based not of fixed range like in the example above - but ask Excel to compute last value range ? (Something like "Ctrl+Shift+Arrow_Down" combination ? Could it be used for SERIES
    data type in Excel ?

  2. #2
    Valued Forum Contributor
    Join Date
    07-11-2004
    Posts
    851
    you can define a range name of variable length - place something like the below in the range when you define the name - you can then refer to the range name in your graphs

    =Sheet1!$A$1:OFFSET(Sheet1!$A$1,COUNTA(Sheet1!$A$1:$A$1000)-1,0,1,1)
    not a professional, just trying to assist.....

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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