Chart with VBA (1 Viewer)

Hi friends,

I am trying to create a Chart with my data in MS excel using a Button but somehow I am not able to create it. I am creating the Chart but I am not able to create different series in the chart thats why my diagram is not giving me the required results.. I am attaching MS Excel file with data and the required data which I have created manually and the button which should create that diagram but shows something very funny. Could you give me suggestion how to create the shown diagram with my vba code?

Thanks

Howdy. Check out Jon Peltier's VBA approach to charts dealing with series.