automatically update graph from data on seperate worksheet

[Jeffsk]

Another +/- newbie question.

How do I get my graph to automatically update when the data (on a seperate worksheet, in the same workbook/file) is changed/updated/added to?

I deleted the graph & selected the data ranges as a table but all the formatting seemed to be lost so I didn't continue with that process.

Thanks

 

[Kaper]

I probably don't understand question, because the graph shall update itself automatically after the source data values (but not range - see below) are changed.
Or if it is a pivot graph, you shall update (refresh) the pivot.
Or yet another option - you have automatic calculation switched off. So to let graph reflect changes in data values - use F9 to recalculate workbook.
Or yet another option - you just add data to old set (probably below old data) and the graph does not include it automatically. If it is the case, consider having data in Excel table (Insert->Table) and refer to table while graph is created. When you add new data to the table, it will be automatically included in the graph. In Excel 2019 it usually works also for not table-contained data, but it seems that in your case it's not working

Just refering to added table - once you have data in a table and want to replace it with new one, don't delete old table, just clear the contents, and then insert new one. Table atays there (may be shrinks or extends verically because of differences in number of data points.

 

[Jeffsk]

I probably don't understand question, because the graph shall update itself automatically after the source data values (but not range - see below) are changed.
Or if it is a pivot graph, you shall update (refresh) the pivot.
Or yet another option - you have automatic calculation switched off. So to let graph reflect changes in data values - use F9 to recalculate workbook.
Or yet another option - you just add data to old set (probably below old data) and the graph does not include it automatically. If it is the case, consider having data in Excel table (Insert->Table) and refer to table while graph is created. When you add new data to the table, it will be automatically included in the graph. In Excel 2019 it usually works also for not table-contained data, but it seems that in your case it's not working

Just refering to added table - once you have data in a table and want to replace it with new one, don't delete old table, just clear the contents, and then insert new one. Table atays there (may be shrinks or extends verically because of differences in number of data points.

Sorry, but I don't really understand much of what you've written above.
Thanks anyway

 

[Kaper]

So let's focus on IMHO best way: