Mega Code Archive
To move the chart to another worksheet as an embedded object
Click the chart. Click the Design tab under Chart Tools.
Click the Move Chart button.
Click the New sheet option, and then type a new name for the chart tab.
Or click the Object in option, and then select the worksheet you want.
Click OK.