I am running Excel 2016, using Microsoft query connecting to sql server retrieving some data into a pivot table and creating a graph, this works fine.
I have a cell that I can change the date I am interested in, the underlying data then changes, but I have to right click on a graph and say refresh.
Is it possible to have the graph refresh when the data does? I have seen examples of charts changing when the data is in excel, but can't seem to find anything when pulling from an external data source. thanks