In Microsoft Chart, you can create a new series from an existing series with the Analyze command from the Data menu.