Is there a way to update the graph when the data table changes? The table range stays the same, only numbers in table change.
If the source range expands, I already know, how to manually change it. The graph adds then a new column based on the data. All well in that case. However, when the range stays the same but the numbers in table change, I can’t seem to be able to update the graph.
Doing the same graph over and over after each data update is tiresome. There should be a way to update the graph, when the data in specified table range changed.
Thank you