Use the completed version of your Assignment #1 - Retirement planner model. In the original, the chart just plotted the Year End Balance as a single series and was therefore one color for both the working years and the retirement years. The objective of this problem is primarily to distinguish between the two periods on the chart. You could accomplish this by creating two separate columns: one for the working years - it would have the savings balance during the working years and #N/A errors during the retirement years and a second column to with #N/A errors during the working years and the correct savings balance during the retirement years. This is effectively what the retirement planner template used to accomplish this task (they of course hid the two columns on the Calculations worksheet). This would make the table look strange and besides I want you to accomplish this by creating named formulas that reference the correct portions of the range