Produce a Pareto Chart using Excel

The result of this exercise/answer is a Pareto Chart, showing the following: the bar chart and a curve line and 80% cut off ( 80/20 rule)

Y axis on the left side =frequency / count

Y axis on the right side = cumulative %

X axis shows the types of complaint clearly label.

Each column shows the complaint with the count number on the top of the bar

Title : Customer complaint survey data over 30 days

Please show your excel calculations step by step. I tried the following steps provided by my tutor but I was stuck.

1. I selected columns Complaint Type, Count and Cumulative %

2. On the Insert tab, in the Charts group, click the Column symbol.

3. Click Clustered Column , select the 2 D column

4. I was stuck in the following steps in the example given by my tutor:

I would like to get the results in the same format as shown in this example.