The line chart in the range H16:L33 compares the amount of principal and interest paid each year of the loan. Nadia wants to make the chart more prominent on the worksheet and easier to interpret.
Add a border to the chart using the Lavender, Accent 1 shape outline color and a 1½ point weight. Add the default data table (with legend keys) to the chart to show the principal and interest values for each year. In excel
, you can follow these steps to make the chart more prominent and easier to interpret:
1. Click on the line chart in the range H16:L33 to select it.
2. Click on the "Format" tab in the Excel ribbon.
3. In the "Shape Outline" dropdown menu, select "Weight" and choose "1 1/2 pt" to add a border to the chart.
4. In the same "Shape Outline" dropdown menu, select the "Lavender, Accent 1" color to change the color of the border.
5. Click on the chart to select it again, then click on the "Chart Elements" button (the plus sign icon) on the upper-right corner of the chart.
6. Check the box next to "Data Table" to add a default data table to the chart that shows the principal and interest values for each year.
7. You can further customize the data table by right-clicking on it and selecting "Format Data Table." From there, you can adjust the font size, color, and other formatting options to make it more visually appealing and easier to read.
By following these steps, you can make the line chart more prominent and easier to interpret on your worksheet.