134 Excel | How to display a contribution of each value to a total on a chart?

Best used for contribution display is a pie chart. Select your
table only including the cells you wish to be presented on the
chart and go under Insert tab into Charts section. Under “Pie”
choose the type of the pie chart that suits you best. Unfortunately
no live preview is applicable in this case. - Office ToDo