title: Avoid Excel Chart streching line till end after series flattens
body: <p>I have a table of total 12 columns and 30 rows. The table looks like below. Note that real data are very different than this, but follows this pattern - the value goes upto some number and keeps repeating for all rows.</p>
  <p><a href="https://i.stack.imgur.com/bykHe.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/bykHe.png" alt="Tabele" /></a></p>
  <p><sup><a href="https://itty.bitty.site/#/data:text/html;charset=utf-8;bxze64,XQAAAALtDwAAAAAAAAAeHQgmOm3if1cj0EddAG11avRu8JLrozXRddsoRVlEd631IerpCKQfigEc8T8FEZhUU7X1paUA4ze/L12GuEHEWdxGrPN7RriVyiuMCV1lKkGw5w9rPTQEK2e7EX5h7qQPVcMiU/xHCCriHNCsjAPdUlLJf6N56ww2Kgy+JVx9lHIbETfbehX8OWNZK+/0JXaxk5xSuxQvkEOwGULRsWjy2RsUWore0sHScBSFoCSB+1CYkNEaliLyzIaJroBLZ7yFA46HO0IGjiyXT0mQSriKwv3a5nWhEEfb7LI2IzMwtU1lQ4UfeK6dQBgq4ftKKJ1f/62yKwA=" rel="nofollow noreferrer">Data</a></sup></p>
  <p>I want to plot a line chart that looks like this-</p>
  <p><a href="https://i.stack.imgur.com/6OPCq.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/6OPCq.png" alt="Expected output" /></a></p>
  <p>But I am getting this-</p>
  <p><a href="https://i.stack.imgur.com/CgvWi.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/CgvWi.png" alt="Actual output" /></a></p>
  <p>I am able to get an expected chart by manually deleting repeating values from the table. I am looking for a way to do that automatically.</p>