I did manually create a graph on a sheet called "Graph" according to a sheet called "Project Manager". Each project has a graph with their detail to show their performance.

IN VBA part, I did create a button to add project manager to add and delete the Project Manager. Now the problems is, when i delete a project manager, the Graph do not intelligent enough to update the source in the graph to appropriate Project Manager, now all the Graph information is wrong because they are refering to address, not to correct Project Manager.

Is there anyway to solve this problems? Thanks for helping.