before:
  table A1:D5
  series 1: =SERIES(Sheet1!$A$1,,Sheet1!$A$2:$A$5,1)
  series 2: =SERIES(Sheet1!$B$1,,Sheet1!$B$2:$B$5,2)
  series 3: =SERIES(Sheet1!$C$1,,Sheet1!$C$2:$C$5,3)
  series 4: =SERIES(Sheet1!$D$1,,Sheet1!$D$2:$D$5,4)
table grown by Excel as typed
after:
  table A1:D6
  series 1: =SERIES(Sheet1!$A$1,,Sheet1!$A$2:$A$6,1)
  series 2: =SERIES(Sheet1!$B$1,,Sheet1!$B$2:$B$6,2)
  series 3: =SERIES(Sheet1!$C$1,,Sheet1!$C$2:$C$6,3)
  series 4: =SERIES(Sheet1!$D$1,,Sheet1!$D$2:$D$6,4)
