Rolling chart troubleshooting

[DanielleRose]

Hey!
I'm currently building a rolling chart for work and I'm having some issues with having it "roll". I used and compared two different tutorials and (I believe) followed it step-by-step. Yesterday afternoon I finally got it to work but today when I pulled it up it was no longer working - If I add another date to the table it will add it to the chart but still display the September 6th entry when it should not. It is intended to have 13 weeks worth of data. I've ran through the same process 2 more times and can't seem to figure it out. Can anyone spot what I'm missing?

Thanks

 

[Sergius]

Hello! So on your diagram you have data for 13 weeks. Or did I misunderstand you?

 

[DanielleRose]

Hello! So on your diagram you have data for 13 weeks. Or did I misunderstand you?

Hey! Yes, I do have 13 weeks of data currently on it which is what I'm wanting, but whenever I add in another row to the table it adds a 14th point on the chart rather than just use the most recent 13 weeks of data. I'm hoping that makes sense.

 

[Sergius]

You need to change your approach to diagramming. Something like this.