+ Reply to Thread
Results 1 to 2 of 2

Charting Offset Functions

  1. #1
    Registered User
    Join Date
    07-07-2008
    Location
    DC
    Posts
    1

    Charting Offset Functions

    Hi,

    I have a series of offset functions in a column...

    =OFFSET(Sentiment!$A$1,0,0,COUNTA(Sentiment!$A:$A),3)
    =OFFSET(Sentiment!$E$1,0,0,COUNTA(Sentiment!$E:$E),3)
    etc.

    Each offset refers to three columns in my data set: the date, the last price, and the year over year value.

    I want to chart the values that each offset function refers to. When I go to a chart and enter the offset function into the data range, it works. However, it changes the offset function to what it refers to (for example, =OFFSET(Sentiment!$A$1,0,0,COUNTA(Sentiment!$A:$A),3) becomes =Sentiment!$A$1:$C$104).

    As a result, when the data changes, the chart fails to update.

    How can I have the data range always have the offset function, or even the cell that I keep the offset function in?

    Thanks

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578
    Use your Offset functions within defined names (Insert > Name>Defined Name) and refer to those names in your chart sources(e.g. x axis =Sheet1!Name1). Let us know if you have problems.

    ChemistB

+ 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