Open the Excel file that has the chart you want to convert. Click on the chart to display the Chart Tools tab, and then click the "Design" tab. Click "Change Chart Type" in the Type group to open ...

If you wish to create a a Pivot Table and Pivot Chart in Excel, then this detailed article will guide you through the entire process.