Plot Graph in accordance to data

Hello Friends,

I have graph in Sheet "G1" & Sheet "G2" with source data in it...


Now the problem here is that..
The source data gets populated from a macro & then we refresh the graph or update the graph data manually...

example..

1) We have Parameters from (AX1 to Ax7) now there can be more parameters.
2) We have 3 names (Ram, Pam & Sam) now there can be more names...


How can we do a macro which will update the graphs in accordance to the data.. no matter how much data is..
the graph type & format is fixed by customer so we cant change..

Please suggest...

same goes for Sheets ("G2")

Thanks Loki...... but somehow I was able to build the VBA code for the same.. thank you so much for revert