+ Reply to Thread
Results 1 to 6 of 6

Excel Chart Help....vI need help in making chart, chart should take the last 12 value

  1. #1
    Registered User
    Join Date
    08-07-2011
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    6

    Excel Chart Help....vI need help in making chart, chart should take the last 12 value

    I need help in making chart, chart should take the last 12 values from the list of n values.( For eg : original list contains A2:A18 data , chart should take the values from A6:A18, If the data added again in list A2:A19 , then chart shld take value from A7:A19 automatically), pls guide me.. waiting for response ...

    Thanks in advance for ur help....

  2. #2
    Forum Guru
    Join Date
    05-24-2011
    Location
    India
    MS-Off Ver
    Office 2021
    Posts
    2,237

    Re: Excel Chart Help....vI need help in making chart, chart should take the last 12 v

    Hello Jeevitha,

    See the attached. If doesn't have 12 entries it will adjust to available entries. If do have more than 12 entries will show the last 12 data.

    If this is not you are looking, please attach a dummy file.
    Attached Files Attached Files
    Regards,
    Haseeb Avarakkan

    __________________________________
    "Feedback is the breakfast of champions"

  3. #3
    Valued Forum Contributor scottylad2's Avatar
    Join Date
    09-03-2010
    Location
    edinburgh
    MS-Off Ver
    Office 2007 Prof & Office 2010 Student Edition
    Posts
    629

    Re: Excel Chart Help....vI need help in making chart, chart should take the last 12 v

    Something like this maybe,
    Attached Files Attached Files
    Windows 7 using Office 2007 & 2010

    Remember your [ code ] [ /code ] tags, makes reading soooo much easier

  4. #4
    Registered User
    Join Date
    08-07-2011
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Excel Chart Help....vI need help in making chart, chart should take the last 12 v

    Thanks all !!!!

  5. #5
    Registered User
    Join Date
    08-07-2011
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    6

    Question Re: Excel Chart Help....I need help in making chart, chart should take the last 12 v

    Quote Originally Posted by Haseeb A View Post
    Hello Jeevitha,

    See the attached. If doesn't have 12 entries it will adjust to available entries. If do have more than 12 entries will show the last 12 data.

    If this is not you are looking, please attach a dummy file.
    Hi ,
    I have attached sample file.. i am not getting output for 3 and 4th formula,, pls pls help me....Waiting for reply... Thanx a lot in advance ....

    Data.xlsx

  6. #6
    Forum Guru
    Join Date
    05-24-2011
    Location
    India
    MS-Off Ver
    Office 2021
    Posts
    2,237

    Re: Excel Chart Help....vI need help in making chart, chart should take the last 12 v

    Jeevittha, see the attached.
    Attached Files Attached Files

+ 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