Adding the title
Now that the data and x-axis have been added, the next step is to add a title to the visualization so that users can understand what the visualization is supposed to measure.
For the 2 loan visualization graphs, the goal is to measure the percentage paid to interest and principal over time and the cumulative payments over time. Entering in a new chart title can be found in the Customize menu under Chart and Axis Titles.
You should only need to change the title, not the axis labels.
After this correction, you'll still see blank space on the x-axis. Don't worry! We'll be fixing that after the next video.
This exercise is part of the course
Loan Amortization in Google Sheets
Exercise instructions
- Add the title "Interest and Principal Percentage over Time" to the visualization in cell
E1
. - The title must be exactly "Interest and Principal Percentage over Time". No additional spaces or changes in capitalization! It can be easier to copy and paste the text.
- Do not move the visualization from cell
E1
.
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
