5 Replies Latest reply on Jul 24, 2018 12:33 PM by Mahfooj Khan

# Cumulative Percentage Chart?

I'm looking to make a cumulative percentage chart that would look something like this

The Y-axis would be Cumulative Percentage while the x-axis would be Wait Time. I created a sample table below as my table structure is similar but confidential. I'm assuming these two columns would be all I need to create this chart

# of SalesWait Time
101
1123
5235
610
10
311
578
2325

I'm assuming I need to make the x-axis (wait time) discrete instead of continuous? i.e. the x-axis would only go up to 35. If so, how would I create the rest of the graph? It seems like the points is a product of the two columns (10x1, 11x23, 52x35,...)

• ###### 1. Re: Cumulative Percentage Chart?

you talk about pareto chat??

• ###### 2. Re: Cumulative Percentage Chart?

there is no way to create similar chart you show with given data.

Then, not sure what you are asking, but from given data , the graph can be like this.

Thanks,

Shin

• ###### 3. Re: Cumulative Percentage Chart?

Hi,

The screenshot looks like Pareto chart.

Is that what you wants?

Drag the fields and apply two table calculations like this

Workbook attached for your reference. Let us know if this help.

Mahfooj

• ###### 4. Re: Cumulative Percentage Chart?

Thank you!

• ###### 5. Re: Cumulative Percentage Chart?

You're welcome