12 Charts
- Page ID
- 361947
Video \(\PageIndex{2}\): 3:49 video developed by Liliane Poirot on inserting and editing a chart (https://youtu.be/201tlRiHmw0)
Insert a Chart
To insert a chart first highlight the cells you want in your chart
If you highlight the columns this will use all data in those columns which is useful if you add more later
Next click Insert then Chart
Edit a Chart
To edit a chart click the three dots in the right hand corner of the chart, this will open the chart tool bar to the right.
Setup lets you choose the type of chart and the other basic set up for the chart. Figure 1 below explains the different options in the setup menu.
You can also customize a chart using the customize tab. This lets you change the look of a chart.
Chart & Axis Titles
You can change the title of the chart or the x and y axis of a chart. If you have Use row 1 as headers checked the sheet should automatically use your first row as the title for the axis.
To change the title you can go to the chart toolbar then customize and select Chart & Axis Titles.
You can switch between the Chart Title, the Horizontal Axis (x), and the Vertical Axis (y) and change the title text.
Alternatively you can change the text by double clicking on the title you want to change