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.
To add a border to the chart using the Lavender, Accent 1 shape outline color and a 1½ point weight, follow these steps:
1. Click on the line chart in the range H16:L33 to select it.
2. In the Chart Tools Format tab at the top of the Excel window, click on the Shape Outline dropdown menu.
3. Select "Weight" and choose "1.5 pt" to set the weight of the border.
4. Then, click on the Shape Outline dropdown menu again, go to "Colors" and choose "Lavender, Accent 1" to set the color of the border.
To add the default data table with legend keys to the chart:
1. Click on the line chart in the range H16:L33 to select it.
2. In the Chart Tools Design tab at the top of the Excel window, click on the "Add Chart Element" button.
3. Hover over "Data Table" in the dropdown menu that appears and select "With Legend Keys" to add the data table to the chart.
These steps will help make the chart more prominent on the worksheet and easier to interpret for Nadia.