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.

Before you convert your Excel data into a table, make sure you have column headers along the top row. This will make dealing with and using the data much more straightforward down the line.

Slicers are a good way to filter data in a Microsoft Excel PivotTable or PivotChart, but they take up a bit of room. By moving the buttons to the chart, you free room for more visuals.

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.