How to Create Charts in Excel 2016

In this tutorial, we’re going to show you how to create charts in Excel 2016.

To get started, select your data to use for the chart. In the example below, I’ve selected the Company 1 cell, and then held Ctrl and selected the other cells excluding Current Quote. Thus, my title will be Company 1, and it will plot the data points selected.

Create Charts in Excel 2016

Go under the Insert tab and find the graph that suits your needs.

Create Charts in Excel 2016

Your graph should now have been inserted. Hover over it until the cursor changes as shown below, then click and drag to position it wherever you want it.

Create Charts in Excel 2016

If a chart element that you want is not on the chart, or you want to remove an element, click the plus sign over to the right of the chart and make your changes.

Create Charts in Excel 2016

To change a certain element (the Legend for example), right-click it and click Select Data…

Create Charts in Excel 2016

Then click Edit as shown below. The Edit button on the left, which corresponds to the Legend.

Create Charts in Excel 2016

Then simply select the cell(s) for the data. In this case, the Legend uses a single cell, so I selected Current Quote as the value for the Legend.

Create Charts in Excel 2016

If you wanted to change the x-axis values to dates or anything else, simply right-click on the axis and hit Select Data…

Create Charts in Excel 2016

Then click the Edit on the right side, which corresponds to the x-axis.

Create Charts in Excel 2016

Select the data range to use. For this example, I have the dates already typed out. This is helpful because the same data range can be reused for multiple charts.

Create Charts in Excel 2016

To change the format of the axis, select it in the chart and use the options in the menu to the right which is highlighted below.

Create Charts in Excel 2016