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.

How to create a Pivot Chart in Excel Once you have created the Pivot Table, you can make a Chart of it. The procedure is as follows: Select the range of cells across the Pivot Table.