Problem

(a) Use Excel to prepare a line chart to display the following gasoline price data. Modify...

(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? Hint: Do not include the years when you make the chart. After the chart is completed, you can right-click the chart, choose Select Data, select Horizontal Axis Labels, and then click Edit to insert the range for the years as X-axis labels.

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