this question is in excel. please provide an explanation on how to do it in excel.

Draw Page Layout Formulas Data Review View Shape Format Tell me d Get Add-ins hi Map Divatchat Board Recommended Charts Link commended to NyotTablet Timeline My Add-ins Data from Victures Shapes Toons Picture Data from Picture M N 0 D a Vehicle Production Data. The International Organization of Motor Vehicle Manufacturers (officially known as the Organisation Internationale des Constructeurs d'Automobiles, OICA) provides data on worldwide vehicle production by manufacturer. The following table shows vehicle production numbers for four different manufacturers for five recent years. Data are in millions of vehicles MANUFACTURER TOYOTA GM VOLKSWAGEN HYUNDAI Products (millions of vehides) Year 1 Year 2 Year 3 Year 4 Year 5 804 853 7.21 8.56 397 935 6.46 143 5.68 627 6.44 607 7:34 251 5.76 a. Constructa line chart for the time series data for years 1 through 5 showing the number of vehicles manufactured by each automotive company. Show the time series for all four manufacturers on the same graph b. What does the line chart indicate about vehicle production amounts from years 1 through SP Discuss c.Construct a clustered bar chart showing vehicles produced by automobile manufacturer using the year 1 through data. Represent the years of production along the horizontal axis, and cluster the production amounts for the four manufacturers in each year. Which company is the leading manufacturer in each Year