+ Reply to Thread
Results 1 to 2 of 2

chart auto update

  1. #1
    Registered User
    Join Date
    05-27-2014
    Posts
    5

    chart auto update

    Is there a way to have a line chart linked to a table such that it graps the last 10 entries of the table? So for example, if I had 12 rows, it would graph rows 3-12, but if I added a 13th row, it would automatically update and graph rows 4-13. I already have my table set up such that my chart automatically updates with new rows, but I want it so it only shows the last 10 rows of my table.

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: chart auto update

    Sounds like you need to use a dynamic range.

    Have a look at

    http://office.microsoft.com/en-gb/ex...001109801.aspx
    Martin

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] chart auto update
    By navwelch in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-02-2012, 08:01 AM
  2. Excel 2007 : Turn off chart auto-update?
    By Raveydavey in forum Excel General
    Replies: 1
    Last Post: 06-11-2010, 05:58 PM
  3. Chart Auto Update
    By Reyan123 in forum Excel General
    Replies: 1
    Last Post: 07-19-2007, 08:48 AM
  4. auto update of a chart
    By TUNGANA KURMA RAJU in forum Excel General
    Replies: 1
    Last Post: 06-24-2006, 05:00 AM
  5. [SOLVED] Chart does not Auto-update anymore .Why?
    By Goat Sandwich in forum Excel General
    Replies: 2
    Last Post: 08-22-2005, 05:05 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