Tallridge Regional Medical Center Budget Department 2018 2019 2020 2021 2022 Trend Coronary Care $ 4,590,049 $ 5,108,725 $ 4,991,224 $ 5,250,768 $ 5,124,750 Emergency 14,003,329 16,089,825 17,183,933 18,782,039 19,702,359 Endocrinology 2,775,520 2,850,459 2,841,908 2,847,592 2,893,153 Intensive Care 8,755,483 8,895,571 9,073,482 9,282,172 9,254,325 Neurology 5,095,866 5,289,509 5,363,562 5,283,109 5,864,251 Obstetrics 10,258,041 10,093,912 10,659,171 11,010,924 11,308,219 Oncology 10,617,497 10,734,289 11,732,578 12,448,265 13,518,816 Radiology 10,670,979 10,606,953 10,797,878 10,927,453 12,402,659 Total $ 66,766,764 $ 69,669,243 $ 72,643,736 $ 75,832,322 $ 80,068,532 On the Budget worksheet, create a 2-D pie chart based on the non-adjacent range A5:A12 and F5:F12. Modify the chart as described below: Resize and reposition the chart so that the upper-left corner is located within cell H4 and the lower-right corner is located within cell O22. Apply Chart Style 3 to the chart. Enter 2022 Budget by Department as the chart title,



Answer :

Other Questions