Results 1 to 4 of 4

Dynamically Graphing using Offset leading to odd behavior

Threaded View

  1. #1
    Registered User
    Join Date
    01-13-2016
    Location
    Columbus, Ohio
    MS-Off Ver
    2010
    Posts
    1

    Lightbulb Dynamically Graphing using Offset leading to odd behavior

    I am using OFFSET to Dynamically graph data based on Pivot Table Slicer Selections. When I graph the data where the returned value is not equal to "". I have one chart that will graph the 'in between' date ranges even though they are not in the charting area. This first graph uses the offset function.

    A second graph graphs uses the off set function as well except the difference is the second graph graphs one extra row. As you can see in the attached excel this changes the format of the graphs.

    One graph graphs the seemingly non existent months while the other graph skips over the missing months and adds a space at the end. Even though they are both graphing the same exact data.

    Can any explain why the first graph graphs the gaps and why graphing an extra row will remove these gaps?

    Also, any fixes to this so it works correctly? (no gaps at all)
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 06-22-2014, 04:18 PM
  2. [SOLVED] Behavior of Offset function in an array formula
    By mohd9876 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-05-2012, 07:40 AM
  3. Replies: 2
    Last Post: 08-09-2012, 09:16 AM
  4. function similar to offset to offset the offset
    By Jerseynjphillypa in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-03-2012, 03:07 PM
  5. Linking dynamically allocated row offset to stacked column chart data range variable
    By amanagarwal in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-05-2011, 02:25 PM
  6. Graphing dynamically using Excel
    By controlfreak in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-03-2009, 09:34 AM
  7. Using offset within a formula dynamically
    By S Davis in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-28-2006, 10:15 AM

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