MS. GALVINHILL COMP. CLASSES - Home



To create a pie chart in Excel 2016, you will need to do the following steps:Highlight the data that you would like to use for the pie chart. In this example, we have selected the range A1:B5.Select the Insert tab in the toolbar at the top of the screen. Click on the Pie Chart button in the Charts group and then select a chart from the drop down menu. In this example, we have selected the first pie chart (called Pie) in the 2-D Pie section.Now you will see the completed pie chart. In this tutorial, the pie chart has 4 slices (one for each division). Each slice represents the sales as a percentage of the total sales.To create a column chart in Excel 2016, you will need to do the following steps:Highlight the data that you would like to use for the column chart. In this example, we have selected the range A1:C7.Select the Insert tab in the toolbar at the top of the screen. Click on the Column Chart button in the Charts group and then select a chart from the drop down menu. In this example, we have selected the first column chart (called Clustered Column) in the 2-D Column section.Now you will see the column chart appear in your spreadsheet with rectangular bars to represent both the sales and the expense numbers. The sales values are displayed as blue vertical bars and the expenses are displayed as orange vertical bars. You can see the axis values on the left side of the graph for these vertical bars.Finally, let's update the title for the column chart.To change the title, click on "Chart Title" at the top of the graph object. You should see the title become editable. Enter the text that you would like to see as the title. In this tutorial, we have entered "Sales and Expenses" as the title for the column chart.Now make a pie chart showing how many hours you spend on different activities on a normal school day. You should have two columns of data. One column should be titled “Activity” and the other should be titled “Time.” Your numbers in the Time column should add up to 24. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download