How to create a dynamic chart by using VBA & MACRO ?

I would suggest you for using dashboard and slicer rather than VBA, you can develop a quality interactive dashboard for financial reporting. I can support you if needed

thanks

did you try PivotChart??

It can be dynamic and customized with no macros needed

To answer your question, the best way is to record macro, then modify code to match your needs

think about this:

just record a macro using automatic macro recorder.

review the code.

make it suite your needs

done.

the dynamic chart used by vba for very easy first are drawn the chart after that inser button click to appear the dynamic chart