hey yall,
i have recently inherited some Excel files that contain graphs. i edit the information and update the graphs each month. Usually when i click on a graph boxes will appear that show you the data that is being used. When you want to update the graph you just increase the range by moving the colored lines. However, some of the graphs that my boss initially created do not work that way. i have to go into the source data and recapture the data each time.
This is not that big a deal, but i was wondering how to fix them so that they work in the same manner as the ones i described first...
thanks