how to make a pie chart in excel using my own data

After this, you need to hide below half of the chart.In “Format Data Series”, enter 270° in “Angle of first slice” and hit enter.From here the next thing is to change the angle of the chart and for this right click on the chart and then click on “Format Data Series”.Once you click OK, you’ll have a doughnut chart just like below.After that, select the “Value” column from the first data table. In the “Select Data” window, click on “Legend Entries” and enter “Category” in the name input bar.Now, right-click on the chart and then click on “Select Data”.First of all, go to Insert Tab ➜ Charts ➜ Doughnut Chart ( with this you’ll get a blank chart).Pie charts are a great way to present numerical data because they make comparing the magnitude of various numbers quick and easy, while also making the larger data set appreciable at a glance.To create a SPEEDOMETER in Excel, you can use the below steps: But when your team can see the data laid out in a visual format, suddenly it all makes sense. Numbers aren't that interesting when spoken about. Think something like this: 'We allocated 10% of operating budget to maintenance, 15% to hardware upgrades, 18% to renegotiated insurance and…' so on. One option for sharing reports with your team is to simply rattle off numbers.

Visit Business Insider's homepage for more stories.Pie charts can be moved around within the Excel sheet and can also be dragged into other programs, such as Word or PowerPoint to dress up reports, presentations, and papers.Excel can use the information already entered into a series of cells aligned in either a row or column of a spreadsheet to make a pie chart.You can easily make a pie chart in Excel, which is a great way to make numeric data appreciable at a glance, without the need for a deep dive into facts and figures.

How to make a pie chart in excel using my own data