Updating Pie Charts Series Values with unpredictable source data

BMoe,

Thank you for your reply.

In the attached workbook I'm trying to update Chart 6 on the Phone Graphs Roll tab with data from LVL1 GRAPH DATA tab. The main issue causing the problems is finding the last cell need for the series values. The number of metrics that can return on a any given month can be more or less than the previous.

Thank you for your help.
Michael