VBA Code to create summary table and Chart

Hi,

Can you please help me with the below query please:

Need VBA code that creates summary table for the given input data and then create the chart for the summary table; data always does not remain the same; columns wud be the same but data points might increase; so while creating the chart it has to automatically pick up the range of the summary table; and then copy-paste this chart in PPT.

thanks in advance.