Results 1 to 6 of 6

dynamic chart data includes one row too many

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-03-2008
    Location
    Key West, FL
    MS-Off Ver
    365 Apps for Enterprise
    Posts
    666

    dynamic chart data includes one row too many

    I have a chart which uses data from an array which increases in size as I add data daily.

    I'm having problems with the final row or two of data. Note how the attached chart line "drops off".

    the horizontal axis is the date:

    =OFFSET(results!$AE$23,0,0,COUNTA(results!$A$23:$A$64000),1)

    the vertical axis is a set of data (beginning at about 0 and rising to about 16,000):

    =OFFSET(results!$AF$23,0,0,COUNTA(results!$AF$23:$AF$64000),1)

    the chart data begins at row 23 and should go to row 908, and stop there. But it seems like it keeps going. Any ideas (aside from cropping the pic?) Thanks!
    Attached Images Attached Images

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