Microsoft Excel is an application for managing of spreadsheet data. Once your data is formatted, making a pie chart only takes a couple clicks. This Excel tutorial explains how to create a basic pie chart in Excel 2007 (with screenshots and step-by-step instructions). In your spreadsheet, select the data to use for your pie chart. Next, copy the data from step-1 into Excel. Select the data range (in this example, B5:C14). Select the data range (in this example, B3:C12). Be sure notto select the cells where you totaled things up. One option for sharing reports with your team is to simply rattle off numbers. Highlight the data that you would like to use for the pie chart. In this example, it will come at the sacrifice of the city comparison though. If you wish to display multiple data sets on one chart, consider a different chart, like a line graph. To generate a pie chart in MS Excel 2010, execute the following 3 steps. Each of these chart sub-types separates the smaller slices from the main pie chart and displays them in a supplementary pie or stacked bar chart. In this tutorial, the pie chart has 4 slices (one for each division).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |