Have an excel book that I register my time in various assignments that I have. In the excel book, I have a template that I then use for all assignments. in the template there is a diagram that should show data for the different assignments, but the diagram always looks back to the cells in the template even though I made a copy of the template. what can I do?
