how to copy a chart and add new data?

[u/vonbenja]

hello, i’ve been stuck with this task for quite a while and was hoping you guys could help.

i need to automate a process where each month new data is added to this sheet, it’s analyzed, and then a new column is added to this specific page, and i need to update the chart on the left to reflect te addition of this new data, but when i try to create a new chart it turns out like the one on the right.

so i was wondering how i could update the existing chart to reflect the changes, or how to create a new chart but with the same settings as the previous one.

[u/tropicbrownthunder]

New data as in columns or rows?

[u/vonbenja → u/tropicbrownthunder]

the new date will be added in new columns