Keep cell reference constant in chart with google sheets?

user_2604978 0
Viewed 316

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.

google-sheets
2 Answers

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

user_56326290

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.

user_58580060
Related