CODEWITHSUNDEEP
google-sheets
Bruno
Bruno

Reputation: 101

Keep cell reference constant in chart with google sheets?

I've tried to use the '$' in the data range for a chart, but when I add an additional column, it changes the cells the chart is referring to to the original column.

Everyday I add a column of data to a sheet. I just want the chart to keep referring to that newest column of data instead of referring to the previous day's column of data.

Upvotes: 2

Views: 1377

Answers (2)

player0
player0

Reputation: 1

try this formula and create chart from there:

={INDIRECT("DF!D39:D41"), INDIRECT("DF!"&
  ADDRESS(39, MATCH(MAX(DF!1:1), DF!1:1, 0))&":"&
  ADDRESS(41, MATCH(MAX(DF!1:1), DF!1:1, 0)))}

enter image description here

Upvotes: 2

Anmol Parida
Anmol Parida

Reputation: 688

Do not ad $ Mark and keep adding the columns to the left no to the Right or in between. I tried on a chart and it works.

Upvotes: 0

Related Questions