-1

I want to use the sparkline formula on a fix range("G:P"). Everyday i add another column next to column F into my sheet. So Column "G" becomes "I" and so on. The problem is that the formula does update the range aswell.

=SPARKLINE($G54:BM54)

to

=SPARKLINE($I54:BM54)

Is there a way to prevent that?

TheMaster
  • 45,448
  • 6
  • 62
  • 85
  • It should not be surprising that the address of a referenced cell changed when you moved the referenced cell - you told the spreadsheet that you cared about *that **cell*** - not that *address*. – tehhowch Aug 25 '18 at 13:21

1 Answers1

1

You can use INDEX or INDIRECT:

=SPARKLINE(INDEX(54:54;7):BM54;{"charttype"\"column";"negcolor"\"red";"color"\"green";"axis"\WAHR})

or 

=SPARKLINE(INDIRECT("$G54:BM54");{"charttype"\"column";"negcolor"\"red";"color"\"green";"axis"\WAHR})
TheMaster
  • 45,448
  • 6
  • 62
  • 85