First photo is the questions and information. Second photo is the answer template. Thank you!

PA 8. LO 9.4 The following revenue data were taken from the December 31, 2017, Coca-Cola annual report (10-K): For each segment and each year, calculate intersegment sales (another name for transfer sales) as a percentage of total sales. Using Microsoft Excel or another spreadsheet application, create a clustered column graph to show the 2016 and 2017 percentages for each division. Comment on your observations of this data. How might a division sales manager use this data? \begin{tabular}{|l|l|l|l|l|l|l|} \hline \multicolumn{8}{|c|}{ Intersegment Sales as a K of Total Sales } \\ \hline 09.4 & Europe,MiddleFast,Africa & LatinAmerica & NorthAmerica & AsiaPacific & BotilieInvestmentS. \\ \hline 2017 & & & & & \\ \hline 2016 & & & & & \\ \hline \end{tabular} DON'T FOAGET TO USE THE DATA ABOVE IN 9.8 TO DO YOUA CLUSTERED COLUMN GRAPH on this worksheet belore you rame