Results 1 to 2 of 2

Thread: Line chart that displays a moving block of data

  1. #1

    Question Line chart that displays a moving block of data

    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have to create a line chart that displays 60 weeks out of 4 years.
    The issue is that I need those 60 weeks displayed in the chart to move down the source of data as it's entered each week.

    So looking at the attached image:
    • Column "M" contains percentages that will populate the line chart.
    • The line chart needs to only display 60weeks (rows) out of 262 total weeks (rows)
    • Each week there will be a new percentage added in column "M"
    • The line chart needs to display the new data inputted but stay within 60weeks (rows)

    Another way of looking at it.
    When data is placed in week (row) 100 the chart should display weeks 40 to 100
    The next week when data is placed into week (row) 101 the chart should display weeks (rows) 41 to 101
    AND!! I need this to be automated.
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	Screen Shot 2014-11-12 at 1.47.14 PM.jpg 
Views:	11 
Size:	98.0 KB 
ID:	2831  
    Last edited by Yaboe; 2014-11-12 at 06:51 PM. Reason: spelling

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Excel Version
    Post the workbook.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts