(a) Use Excel to prepare a 2-D pie chart for the following data. Modify the default colors, fonts, etc., as you judge appropriate to make the display effective.

(b) Right-click the chart area, select Chart Type, and change to a 3-D pie chart.

(c) Right-click the chart area, select Chart Type, and change to a bar chart. Which do you prefer? Why? Hint: Include data labels with the percent values.

Dolona Corporation Medical Claims in 2017 Dolona

Spent On                                             Percent of Total
Hospital services......................................................47.5
Physicians.................................................................27.0
Pharmaceuticals.......................................................19.5
Mental health..............................................................5.0
Other............................................................................1.0
Total.........................................................................100.0