Summary: When using spreadsheets on Microsoft Excel, select all of the data in a row, click on the "Insert" tab, and select a type of pie chart. Create a 3D pie chart in a Microsoft Excel spreadsheet with help from a software developer in this free video on Microsoft Excel.
Dave Andrews is a software developer with a business and Web site selling programs and other computer services in Franklin, Tenn. Having worked in the IT industry for more than 8...read more
"Hi, my name's Dave Andrews. Today, I'm going to show you how to make a pie chart in a spreadsheet. Let's go to our computer. And I'm going to open up Microsoft Excel by clicking on my Start button, going to All Programs. Let's find Microsoft Office and click on Excel. Now, I'm going to type in some data into a small spreadsheet, and I'm just going to say employees and their number of sales. I'm going to list out a few employees. And the number of sales that they've had for this quarter. Now, I have my little spreadsheet created, and I'm going to create a chart...actually, a pie chart based upon this data. What I'm going to do is I'm going to click on the very first row. I'm going to hold my mouse button down, and I'm going to drag until it selects all of the data in this spreadsheet. Now, I'm going to go to the Insert tab at the top and under charts, I'm going to hold my mouse over pie, and I'm going to select the type of pie chart that I'd like to put in. I'm going to go with a 3D pie chart because I think that looks neat. Just drop that in there. And as you can see, Excel has automatically created for me a 3D pie chart with a listing of the number of sales. Now, my employees are about equal on there, so I'm going to make one as a little less equality. And just drop one down a bit and go to Insert. I'm going to choose a different type of pie chart this time. And as you can see, it is accurately displaying, sort of, in a pie chart form the number of sales that my employees had. My name's Dave Andrews, and I've just showed you how to create a pie chart in a spreadsheet."
eHow Article: How to Make a Pie Chart in a Spreadsheet