+ Reply to Thread
Results 1 to 3 of 3

Graphing a dynamic range that automatically picks up the most recent entry.

  1. #1
    Registered User
    Join Date
    06-23-2006
    Posts
    13

    Graphing a dynamic range that automatically picks up the most recent entry.

    I'm looking to create a graph that contains series data from a column on another sheet (Weekly), but automatically updates the series X/Y axis (Dates, volume) as new entries are added to the series. Any ideas.

    Series in cell AK4 - AK600 on a sheet called Weekly

    any ideas?


    Thanks
    Gimi

  2. #2
    Registered User
    Join Date
    06-23-2006
    Posts
    13

    More specifically

    I have the range working, but the cells in which data has not been entered into yet has the formula =IF(ISERROR(B52/AE52),"",B52/AE52) in it because is it autmtically calculating weekly percentages based on the input of the daily percentages in the "Daily" worksheet. So, the real problem is creating the dynimic range, but not have the range read cells without values (but possible has formulas).

    Thanks,

    Gimi

  3. #3
    JLeoni
    Guest

    RE: Graphing a dynamic range that automatically picks up the most rece

    If your data is part of a list ( look under data -> list -> create list ),
    then charts will automatically pick up the last entry into the list.
    "gimiv" wrote:

    >
    > I'm looking to create a graph that contains series data from a column on
    > another sheet (Weekly), but automatically updates the series X/Y axis
    > (Dates, volume) as new entries are added to the series. Any ideas.
    >
    > Series in cell AK4 - AK600 on a sheet called Weekly
    >
    > any ideas?
    >
    >
    > Thanks
    > Gimi
    >
    >
    > --
    > gimiv
    > ------------------------------------------------------------------------
    > gimiv's Profile: http://www.excelforum.com/member.php...o&userid=35726
    > View this thread: http://www.excelforum.com/showthread...hreadid=560012
    >
    >


+ 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