Hello.
I am new to macro and still trying to learn.
I have a table of data and 5 graphs, each on a separate sheets, that use the data from the table. Each week I add another entry to the data and then update my graphs. Is there a way to use a macro to automatically update all the graphs at once (I need to extend the ranges on all the graphs to include the new data point)?
I am new to macro and still trying to learn.
I have a table of data and 5 graphs, each on a separate sheets, that use the data from the table. Each week I add another entry to the data and then update my graphs. Is there a way to use a macro to automatically update all the graphs at once (I need to extend the ranges on all the graphs to include the new data point)?