Google Sheets Course: Charts

Insert a Chart

To insert a chart from the following table (lesson-8.xlsx), select the cell range and click on :

google sheets data png charts


The default chart model is then inserted and the chart editor (on the right) is displayed:

google sheets chart insertion png charts

You can then easily change the chart type from the first drop-down list in the editor:

google sheets chart type png charts

From this tab, you can also change the data ranges and other settings that can vary depending on the type of chart chosen.

Customize the Chart

To change the appearance of your chart, click on the second tab "Customize" of the editor:

google sheets customize chart png charts

To modify an element of the chart, you can also double-click directly on this element.

Example with a double-click on the title:

google sheets chart title png charts

By modifying the settings of the "Customize" tab, you will quickly obtain a customized chart:

google sheets black customized chart charts

Explore Panel

Select the cell range and then open the Explore panel by clicking on the button at the bottom right of the screen:

google sheets explore button charts

The artificial intelligence will then seek to determine what could be most useful to you based on the selected data and display it in this panel.

In this case, the AI displays numerical statistics (sum, average, etc.), proposes to format the table with alternating colors and displays different analyses in the form of charts:

google sheets explore png charts

You can insert charts directly from the Explore panel if you wish.