Thank you very much for the reply again. Your solution does show a graph for what I am looking for. I appreciate your input into my problem, as this has been very helpful.

The data that I am working with is currently static based off of a singular export, but if I may pick your brain one additional time, would you have any thoughts on using this set up with dynamic data?

For example if additional Names were added into the data table? I understand that the pivot tables could be refreshed, but as the graph is based off of the values in a created array, they would remain unchanged when the pivot tables have adjusted for the new values.