workahol1c
New Member
- Joined
- Jun 16, 2022
- Messages
- 1
- Platform
- Windows
Hi!
I am needing some help with a problem I have encountered... Data is added every week to this spreadsheet that has line graphs. But the line graphs only have a range of 10 weeks. How do I make it that every time I add data into the spreadsheet, the data range automatically shifts down one cell with leaving the oldest one behind, to respect the 10 week range?
I am needing some help with a problem I have encountered... Data is added every week to this spreadsheet that has line graphs. But the line graphs only have a range of 10 weeks. How do I make it that every time I add data into the spreadsheet, the data range automatically shifts down one cell with leaving the oldest one behind, to respect the 10 week range?