Microsoft in education; Office for students; Office 365 for schools; Deals for students & parents; Microsoft Azure in education. Microsoft Excel Tutorial - Beginners Level 1 - Duration: 32:49. Teacher's Tech 716,572 views. Select data for the chart. Select Insert Recommended Charts. Select a chart on the Recommended Charts tab, to preview the chart. Note: You can select the data you want in the chart and press ALT + F1 to. Select a chart.
How to Create Charts and Graphs in Microsoft Excel 2016. Watch about Microsoft Excel 2016 video tutorial by Simon Sez IT. Learn how to create different types of charts and graphs, such as a clustered column. We will also show you how to resize the chart, change its design, and move it to another worksheet or to a new chartsheet.
Create a Chart | Change Chart Type | Switch Row/Column | Legend Position | Data Labels
A simple chart in Excel can say more than a sheet full of numbers. As you'll see, creating charts is very easy.
Create a Chart
To create a line chart, execute the following steps.
1. Select the range A1:D7.
2. On the Insert tab, in the Charts group, click the Line symbol.
3. Click Line with Markers.
Result:
Note: enter a title by clicking on Chart Title. For example, Wildlife Population.
Change Chart Type
You can easily change to a different type of chart at any time.
1. Select the chart.
2. On the Design tab, in the Type group, click Change Chart Type.
3. On the left side, click Column.
4. Click OK.
![Graphs Graphs](/uploads/1/2/6/3/126375130/311454982.png)
Result:
Switch Row/Column
If you want to display the animals (instead of the months) on the horizontal axis, execute the following steps.
1. Select the chart.
2. On the Design tab, in the Data group, click Switch Row/Column.
Result:
Legend Position
To move the legend to the right side of the chart, execute the following steps.
1. Select the chart.
2. Click the + button on the right side of the chart, click the arrow next to Legend and click Right.
Result:
Data Labels
You can use data labels to focus your readers' attention on a single data series or data point.
1. Select the chart.
2. Click a green bar to select the Jun data series.
3. Use your arrow keys to select the population of Dolphins in June (tiny green bar).
4. Click the + button on the right side of the chart and click the check box next to Data Labels.
Result:
In this tutorial, we will be discussing how to create a basic line graph on Microsoft Excel 2016.
Line graphs are generally used to show trends of a series of data points. It is typically used to show the behavior of a metric / data set over time (week, months year…).
Here are the steps to follow in creating a Line Chart:
How To Create A Chart In Excel
1. Highlight the data set you want to see in a Line Chart. See example below, Range A2:D14 has been selected.
2. Go to the Insert Tab and Click on the Line Chart drop down button in the Charts group and select the first option from the drop down menu.
3. You will then see the Line Chart on the sheet. You can resize the chart by clicking and dragging from the 4 corners of the chart. As you can see, the blue line represents Store A, Orange line represents Store B and the grey line represents Store C.
4. To change the Chart Title, click on the “Chart Title” and Type “Sales Trend by Month” and press Enter
For more options to format the graph, double click anywhere on the chart area, a panel will appear on the right-hand side of the sheet. You can play around the different options available.
Sometimes, you might want to have a combination of Lines and Columns on the graph, to do this, with the graph selected:
![Graph Graph](/uploads/1/2/6/3/126375130/166764752.png)
A. Go to the Design Tab and click on Change Chart Type. It is located on the far-right hand side after Select Data. See image below.
Microsoft Excel Graphs Tutorial Free
B. In this example, we’d like to represent the data for Store A and Store B as Clustered Columns. In the “Choose the chart type and axis for your data series:” section, change the chart type for Store A and Store B as shown below.
C. For Store C, you could also check the Secondary Axis box, so it does not share the same axis with Store A and Store B because they are Clustered columns and Store C is the only data point represented by a Line graph
Microsoft Excel 2013 Graph Tutorial
D. Click OK.
Free Excel Graphs
See below image for the final chart. As you can see it is a combo of Clustered Columns and Line Graph.