始める無料で始める

Adding data to the chart.

In this assignment, you will need to modify one of the 2 visualizations that are being used for the loan dashboard. This visualization is a 100% stacked column chart which measures the percentage of total payments going to interest and to principal.

The other visualization, measuring change in cumulative payments over time, is available for reference. You do not need to add the x-axis or change the title for this exercise.

It is important to capture references that show as #NUM! in the data range for the visualization, since the dashboard needs to be flexible enough to increase the number of possible periods. Removing the #NUM! references will be practiced in a later lesson.

この演習はコースの一部です

Google Sheetsで学ぶローン返済(アモチゼーション)

コースを見る

演習の手順

  • Add the proper data range for the 100% stacked column visualization in cell E1.
  • Do not move the visualization from cell E1.
  • Make sure that the data range extends down to row 182.
  • Interest must be the first series (graphed in blue).

実践的なインタラクティブ演習

理論を実践に変える、インタラクティブな演習のひとつをお試しください

演習を開始する