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.
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.
Attachments
Last edited:
