Create a worksheet in Excel 2016
Excel 2016 makes it easy to crunch numbers. With Excel, you can streamline data entry with AutoFill. Then, get chart recommendations based on your data, and create them with one click. Or, easily spot trends and patterns with data bars, color coding, and icons.
To manually enter data:
Select an empty cell, such as A1, and then type text or a number.
Press Enter or Tab to move to the next cell.
To fill in a data series:
Enter the beginning of the series in two cells: such as Jan and Feb; or 2014 and 2015.
Select the two cells containing the series, and then drag the fill handle across or down the cells.
Create a chart
Easily pick the right chart for your data with the Quick Analysis tool.
Select the range of cells that contain the data you want to show in a chart.
Select the Quick Analysis button in the bottom-right corner of the selection.
Select Charts, hover over each recommended chart, and then pick the chart you prefer, such as Stacked.
Try it! Select File > New, select Take a tour, and then select the Chart Tab. For more information, see Create charts.