+ Reply to Thread
Results 1 to 2 of 2

Vertically Scrolling Dynamic Sparklines

Hybrid View

  1. 02-23-2017, 08:57 AM #1
    hennakao
    hennakao is offline
    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
    Reply With QuoteRegister To Reply
  2. 02-24-2017, 04:46 AM #2
    avk
    avk is offline
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,276

    Re: Vertically Scrolling Dynamic Sparklines

    In cell "L4"
    Formula: copy to clipboard 
    =SUM(Workings!P4:R4)/12
    and copy down.
    You also use
    Formula: copy to clipboard 
    =AVERAGE(Workings!P4:R4)

    atul

    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

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. Can Multiple Columns Be Frozen from scrolling Vertically
    By Aklys in forum Excel General
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1