One option for sharing reports with your team is to simply rattle off numbers. Think something like this: "We allocated 10% of operating budget to maintenance, 15% to hardware upgrades, 18% to renegotiated insurance and…" so on. You've already lost their attention.
Numbers aren't that interesting when spoken about. But when your team can see the data laid out in a visual format, suddenly it all makes sense. 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.
And when you already have a column or row of an Excel spreadsheet loaded with the data in question, you can make a pie chart in about five seconds. Here's how.
Check out the products mentioned in this article:
Microsoft Office (From $139.99 at Best Buy)
MacBook Pro (From $1,299.99 at Best Buy)
Microsoft Surface Pro X (From $999 at Best Buy)
How to make a pie chart in Excel
1. Open Microsoft Excel on your PC or Mac.
2. Open the document containing the data that you'd like to make a pie chart with. Click and drag to highlight all of the cells in the row or column with data that you want included in your pie graph.
3. Click the "Insert" tab at the top of the screen, then click on the pie chart icon, which looks like a pie chart.
4. In the pop-up window, select the chart you wish to use and click on it.
5. Name your new chart, adjust or position it wherever you'd like, and get on with your day.
Related coverage from How To Do Everything: Tech:
-
How to copy a formula in Microsoft Excel using a Mac or PC
-
How to edit a drop-down list in Excel, depending on how you created it
-
How to combine two columns in Microsoft Excel without losing data
-
How to merge and unmerge cells in Microsoft Excel in 4 ways, to clean up your data and formatting
-
How to alphabetize data in an Excel spreadsheet by column or row, and by using shortcuts
Insider Inc. receives a commission when you buy through our links.
