Results 1 to 2 of 2

Vertically Scrolling Dynamic Sparklines

Threaded View

  1. #1
    Registered User
    Join Date
    04-24-2012
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    17

    Question Vertically Scrolling Dynamic Sparklines

    Hi,

    I am currently stuck with my cost dashboard project.

    I have a window of vertically scrolling data and would like to add sparklines, showing a 12 month rolling trend next to it. The sparklines should scroll with their respective data. How can I accomplish this with an INDEX formula? I am trying to avoid OFFSET because it is more resource intensive.

    Please see attached my workbook. Would appreciate if someone can point me in the right direction.

    Thank you!
    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. [SOLVED] dynamic cell range for sparklines
    By coffee_man in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-10-2023, 05:28 AM
  2. Creation of Dynamic Sparklines
    By Dlinen in forum Excel General
    Replies: 7
    Last Post: 10-10-2016, 11:05 AM
  3. [SOLVED] Dynamic Sparklines
    By Salvucio in forum Excel General
    Replies: 8
    Last Post: 01-14-2015, 10:15 AM
  4. Dynamic Chart Vertically
    By Steph12 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 10-31-2013, 01:01 PM
  5. [SOLVED] Vlookup on Dynamic Range that expands vertically and horizontally
    By huy_le in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-27-2013, 03:47 PM
  6. How to keep column A from scrolling vertically
    By mdaniels1982 in forum Excel General
    Replies: 3
    Last Post: 01-03-2013, 10:35 PM
  7. Replies: 3
    Last Post: 01-09-2011, 05:44 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