Hi Excel Forum,
I have two Excel data sets (attached), one for Firm_1 and the other for Firm_2 which shows % distribution of customers in each financial quarter by loan delinquency cycles.
In each quarter, I have to update the each of 3 graphs as new data are coming in.
What I have been doing was this. I go to each graph, right click, then clik “select data”, then click “edit” and expand the data range to capture the newly arrived data points of new quarters.
Q:
I have over 100 graphs to do this exercise, which is strenuous and error prone. Would you please help me to automate the process to reduce the strain and the error of manual exercise.
Thanks for your time and expertise.
Mirisa
Bookmarks