1. Yellow-shaded cells require formulas. The E9 formula must copy down column E. F9 formula must copy down column F. C17 formula should copy across.
2. Create a chart that places Profit on the primary axis, and Profit as a Percent of Sales on the secondary axis. See the example below.
Remember, if you are unsure of what "as a percent" means, just replace it with "divided by".

	Year	Sales	Expenses	Profit	Profit as a Percent of Sales
	2014	$1,000	$ 354	$ 646	64.6%
	2015	1,423	401	$ 1,022	71.8%
	2016	1,698	407	$ 1,291	76.0%
	2017	1,544	476	$ 1,068	69.2%
	2018	2,091	652	$ 1,439	68.8%
	2019	2,015	798	$ 1,217	60.4%
	2020	2,308	806	$ 1,502	65.1%
	2021	2,477	845	$ 1,632	65.9%
	Total	########	$4,739	$ 9,817
	Average	$1,820	$ 592	$ 1,227

Profit $1,800 $1,600 $1,400 $1,200 $1,000 $800 $600 $400 $200 80.0% 70.0% 60.0% 50.0% 40.0% 30.0% 20.0% 10.0% 0.0% $- 2014 2015 2016 2017 2018 2019 2020 2021 Profit -Profit as a Percent of Sales M N 0 Q R S T U V W X Y A B C D E F G H I I K L 1 Coby Formulas and Chart 2 3 1. Yellow-shaded cells require formulas. The E9 formula must copy down column E. F9 formula must copy down column F. C17 formula should copy across. 4 2. Create a chart that places Profit on the primary axis, and Profit as a Percent of Sales on the secondary axis. See the example below. 5 Remember, if you are unsure of what was a percent" means, just replace it with "divided by". 6 7 Profit Profit as a 80.0% 70.0% 60.0% 50.0% Year Sales Expenses 2014 $1,000 $ 354 $ 2015 1, 423 401 $ 2016 1, 698 407 $ 2017 1,544 476 $ 2018 2,091 652 $ 2019 2,015 798 $ 2, 308 806 $ 2021 2, 477 845 $ Total ####### $4,739 $ Average $ 1,820 $ 592 $ Percent of Sales 64. 6% 71.8% 76. 0% 69. 2% 8.8% 60. 4% 65.1% 65.9% Profit 646 1,022 1, 291 1,068 1, 439 1, 217 1, 502 1, 632 9, 817 1, 227 40.0% $1,800 $1,600 $1,400 $1,200 $1,000 $800 $600 $400 $200 $- | 30.0% 2020 20.0% 10.0% 0.0% 2014 2015 2016 2017 2018 2019 2020 2021 Profit 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 Profit as a Percent of Sales Copy and Chart Conditional Formatting Functions Whatif PivotTable PivotChart Macro VLOOKUP IF Charts Import TXT file G +