(a) Use Excel to prepare a line chart to display the following gasoline price data. Modify the default colors, fonts, etc., to make the display effective.
(b) Change it to a 2-D column chart. Modify the display if necessary to make the display attractive.
(c) Do you prefer the line chart or bar chart? Why?

Transcribed Image Text:

Average U.S. Retail Price of Gasoline (dollars per gallon) GasPrice Year Price Year Price 1960 1965 1970 1975 1980 1985 0.31 0.31 0.36 0.57 1.25 1.20 1990 1995 2000 2005 2010 1.16 1.15 1.51 2.30 3.02