1 J K PROBLEMS WITH THE VISUAL: ALTERNATIVE VISUAL: 2000 A B. D E F H 1 Table 1. Total quantities sold per branch per year 2 YEAR 3 Branch 2015 2016 2017 2018 2019 2020 4 Istanbul 1680 1400 2640 2240 1060 1340 5 Izmir 3460 1920 1900 1660 1360 1900 6 Ankara 1880 1480 400 720 1140 1360 7 8 YEARS 2015,2016,2017,2018,2019,2020 9 10 11 12 13 3500 14 3000 15 2500 16 Izmir 17 1500 Ankara 18 1000 Istanbul 500 19 2015 2016 2017 2018 2019 2020 20 Istanbul 1680 1400 2640 2240 1060 1340 21 Ankara 1880 1480 400 720 1140 1360 22 Izmir 3460 1920 1900 1660 1360 1900 23 24 Istanbul Ankara Izmir 25 26 27 QUESTION 10 28 29 (15 points) 30 POINT OUT THE PROBLEMS WITH THE CHART ABOVE. THEN, ADD A BETTER CHART TO THIS PAGE 31 TO VISUALIZE TABLE 1, THAT ADDRESSES THE ISSUES YOU RAISED AND THAT TAKES "THE DO'S 32 AND DONT'S OF DATA VISUALIZATION" INTO ACCOUNT. 33 34 ALTHOUGH GENERATING THE ALTERNATIVE GRAPH HERE WITHIN EXCEL WOULD BE MORE 35 36 CONVENIENT FOR YOU, YOU CAN GENERATE THE GRAPH SOMEWHERE ELSE (POWER BI etc.) AND PASTE IT HERE AS A PICTURE AS WELL. 37 38 39