Hi mbcebrian,

Because of how your data is structured, you will most likely need to use the offset function.

Please check out this post and see if it helps.

Create a Dynamic Excel Pie Chart

This will show you how to create a dynamic chart with a data structure like you have.

Let me know if it helps.

Steve=True