Problem

(a) Use Excel to prepare an appropriate type of chart (bar, line, pie, scatter) to display...

(a) Use Excel to prepare an appropriate type of chart (bar, line, pie, scatter) to display the following data. Modify the default colors, fonts, etc.. as you judge appropriate to make the display effective, (b) Would more than one kind of display be acceptable? Why or why not?

How Confident Are You that You Have Saved Enough to Retire in Comfort?
Confidence Level	1993(%)	2003 (%)
Very confident	18	21
Somewhat confident	55	45
Not very confident	25	33
Don't know	2	1
Total	100	100