1) I need help making the Line with Markers Chart following the directions below

Using the data in the nonadjacent ranges B4:E4 and B10:E10, insert a Line with Markers chart. Position the upper left corner of the chart slightly inside the upper left corner of cell A12. Change the height of the chart to 1.75 inches and the width of the chart to 8 inches. Note, Mac users, change the height of the chart to 1.5 inches.

2)

Apply chart Style 7. Change the chart title to Direct Expenses. Edit the Vertical (Value) Axis so that the Minimum is 8000000and the Major unit is 1000000.

AutoSave OFF A va |_Excel_AIO_Cap1_Year_End_Report Home Insert Draw Page Layout Formulas Data Review View Tell me Share 0 Comments X Gill Sans MT (Head... 18 . ab Wrap Text General LIX WE ( 27.0. F Paste B IU Av $ % ) - Insert Merge & Center Delete Format Conditional Format Cell Formatting as Table Styles Sort & Filter Find & Select Analyze Data A1 fx Direct Expenses by Quarter A B E F G H I J K 1 Direct Expenses by Quarter Summary 2 3 4 5 Sales Expense 6 Administrative Expense 7 Rent Expense 8 Interest Expense 9 Advertising Expense 10 Totals by Quarter Quarter Quarter 2 Quarter 3 Quarter 4 Annual Total % of Total $ 4,458,578 $ 4,678,712 $ 4,887,953 $ 5,325,215 $ 19,350,458 53% 1,311,774 1,587,963 1,689,563 1,856,878 $ 6,446,178 18% 1,317,470 1,317,470 1,317,470 1,317,470 $ 5,269,880 14% 129,713 138,963 115,786 128,963 $ 513,425 1% 964,872 1,184,532 1,278,741 1,581,372 $ 5,009,517 14% $ 8,182,407 $ 8,907,640 $ 9,289,513 $ 10,209,898 $ 36,589,458 12 13 14 15 16 17 18 19 20 Expenses 5-Year Forecast 21 Forecasted Increase 22 Year 23 Projected Expenses 24 25 26 Net Sales by State Sheet1 Ready 3.5% 2019 2020 2021 2022 2023 Net Sales Seattle Inventory Denver Inventory Inventory Summary Sales Reps + Annual Expenses Average: 3569949.708 Count: 59 Sum: 146367938 a + 161% AutoSave OFF A va |_Excel_AIO_Cap1_Year_End_Report Home Insert Draw Page Layout Formulas Data Review View Tell me Share 0 Comments X Gill Sans MT (Head... 18 . ab Wrap Text General LIX WE ( 27.0. F Paste B IU Av $ % ) - Insert Merge & Center Delete Format Conditional Format Cell Formatting as Table Styles Sort & Filter Find & Select Analyze Data A1 fx Direct Expenses by Quarter A B E F G H I J K 1 Direct Expenses by Quarter Summary 2 3 4 5 Sales Expense 6 Administrative Expense 7 Rent Expense 8 Interest Expense 9 Advertising Expense 10 Totals by Quarter Quarter Quarter 2 Quarter 3 Quarter 4 Annual Total % of Total $ 4,458,578 $ 4,678,712 $ 4,887,953 $ 5,325,215 $ 19,350,458 53% 1,311,774 1,587,963 1,689,563 1,856,878 $ 6,446,178 18% 1,317,470 1,317,470 1,317,470 1,317,470 $ 5,269,880 14% 129,713 138,963 115,786 128,963 $ 513,425 1% 964,872 1,184,532 1,278,741 1,581,372 $ 5,009,517 14% $ 8,182,407 $ 8,907,640 $ 9,289,513 $ 10,209,898 $ 36,589,458 12 13 14 15 16 17 18 19 20 Expenses 5-Year Forecast 21 Forecasted Increase 22 Year 23 Projected Expenses 24 25 26 Net Sales by State Sheet1 Ready 3.5% 2019 2020 2021 2022 2023 Net Sales Seattle Inventory Denver Inventory Inventory Summary Sales Reps + Annual Expenses Average: 3569949.708 Count: 59 Sum: 146367938 a + 161%