Results 1 to 7 of 7

Change graphs automatically when a row is inserted

Threaded View

  1. #1
    Registered User
    Join Date
    01-16-2014
    Location
    Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    68

    Change graphs automatically when a row is inserted

    I want the 2 graphs in "Graph" worksheet to change automatically when a row is inserted in "Data" worksheet . Every time i have to change the graph manually to contain the latest 20 days value. I want some offset or something which can be put in the range provided below to do the work.


    Chart Data Range =Data!$A$1:$A$22,Data!$F$1:$F$2,Data!$L$1:$L$20

    Legend entries (Series) -
    Series Name
    =Data!$F$1 ( this will remain constant everyday as this is a header field)

    Series Values
    =Data!$F$2:$F$22 ( this should contain last 20 days range, for example if a next row is inserted tomorrow then
    it should automatically change to =Data!$F$3:$F$23)

    Legend entries (Series) -
    Series Name
    =Data!$L$1 ( this will remain constant everyday as this is a header field)

    Series Values
    =Data!$L$2:$L$22 ( this should contain last 20 days range, for example if a next row is inserted tomorrow then
    it should automatically change to =Data!$L$3:$L$23)

    Horizontal (Category) axis series -
    Axis Label Range
    =Data!$A$2:$A$22 ( this should contain last 20 days range, for example if a next row is inserted tomorrow then
    it should automatically change to =Data!$A$3:$A$23)

    Sheet attached. Please help me as i am a newbie.

    Devicess.xlsx
    Last edited by aakhan2011; 05-26-2014 at 12:54 AM. Reason: solved

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 04-04-2012, 03:39 PM
  2. Need values to be automatically inserted
    By Francoise in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 09-09-2011, 07:42 PM
  3. How to have rows automatically inserted with the tab key
    By friend11_6 in forum Excel General
    Replies: 0
    Last Post: 07-19-2009, 09:02 PM
  4. Automatically Update An Inserted Object
    By Chard in forum Excel General
    Replies: 3
    Last Post: 05-21-2007, 06:23 AM
  5. How can I get inserted lines to automatically appear in a linked .
    By Excel-erator in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-09-2006, 12:55 PM

Tags for this Thread

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