The International Organization of Motor Vehicle Manufacturers (officially known as the Organisation Internationale des Constructeurs dAutomobiles, 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.

DATA: autoproduction.xlsx

Question 1:

Construct a well labelled 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.

Hint: Pivot Data and Format Data T