select the chart and then use the Edit Data in the Design tab of the Chart Tools contextual menu. You should then be able to copy/paste data from excel sheet