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 ...

Follow the steps below on how to ignore blank cells in Excel: Select a blank cell next to the values that you want to use to create the chart and type the formula =IF(ISBLANK(C2), #N/A, C2).

You can easily make a pie chart in Excel to make data easier to understand. The process only takes 5 steps.