I am using a spreadsheet that I have been using for years with Excel. I download financial data, with values of stocks in columns with various weekly totals and a grand total. On another sheet I have created a graph which follows my progress. So…
Each week a new column is created and a total is created in cell XXNN. This will be point number 754 [arbitrary].
On another sheet is a graph with column A having the dates, and column B the value at those dates. Cell Chart.B754 is the next empty cell. I want the function to put the value in XXNN into Chart.B754. I get the Chart address with the concat function, as the next time it will be 755.
I had originally tried naming Chart.B754 = “nextPoint” pasting the value, deleting the name “nextPoint” moving to the next cell down and defining that as “nextPoint”. Recording this cause a bomb. I have not figured out this language being used, so I do not know if this would work if spelled out in a macro. It seems it would be more trustworthy.
Also tried copying the date at the head of the first sheet’s column and searching chart for that date, move right one cell and paste. Could not follow this train.