Question: how to make a pie chart in excel from text?
Answer: In your spreadsheet, select the data to use for your pie chart. ... 
Click Insert > Insert Pie or Doughnut Chart, and then pick the chart you want.
Click the chart and then click the icons next to the chart to add finishing touches: