Dynamic CHART [ HELP! :( ]

[mbcebrian]

Hi i would like to create a dynamic chart for this data without using pivot chart?

Can anyone help me?

[Steve=True]

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