You have a sales report.

This means one sales rep sold 0-5 pieces, two sales reps sold 6-10 pieces and so on.

First, we calculate the cumulative number of sales reps.

Then we calculate the percentual accumulation.

Three sales reps, roughly 11 % of all the sales reps sold 0-10 pieces, for example.

We should create an accumulative curve to see how many sales reps are selling tops 5, 10 or 15 pieces.

Note, that I have emptied B2, the header for X-axis values.

I activated the ranges B2:B7;E2:E7.

Select the correct graph.

I am using the two-dimensional line.

I got right away pretty good graph which does not require much modifications.

The Y-axis is till 120 %.

Activate the Y-axis, so that axis values are in a frame.

Select format axis.

Set maximum to 1,0.

Now the Y axis is up to 100 %.

We can see from the graph that only few percent of sales reps sold tops 5 pieces. Around 10 % of all the sales reps sold up to 10 pieces and roughly one third sold tops 15 pieces. Only about 10 % sold more than 20 pieces.