Share via

Calculating Cumulative Percentage

Anonymous
2013-07-19T01:01:09+00:00

I have created this Pareto Chart

To calculate the Cumulative Percentage I made the intermediate step of calculating individual category percentages.  To do this I had to sum the Number column in B15 and code the cells in Column C individually. 

Is there a formula I could have entered in D3 to calculate the cumulative percentage without the intermediate step and simply copy down the column?

Everything I try requires adjustment cell by cell.

Will this formula cope with the insertion of another row into the table?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2013-07-19T06:12:32+00:00

The only things I would suggest would be to,

  1. Make sure that Formulas ► Calculation Options is set to Automatic
  2. Change the number format to General to see if the result clears up, then back to percent.

I would imagine that B15 holds a formula like =SUM(B3:B14). You can use that in the accumulative percent formula in place of $B$15 like this,

=SUM(B$3:B3)/SUM($B$3:$B$14)

Was this answer helpful?

1 person found this answer helpful.
0 comments

9 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2013-07-19T04:24:39+00:00

    I'm a bit of a newbie at this, and I wouldn't know a pivot table if one jumped up and bit me on the knee.

    Perhaps you could elaborate a little for me.

    Thanks

    Was this answer helpful?

    0 comments
  2. Anonymous
    2013-07-19T04:22:57+00:00

    =SUM(B$3:B3)/$B$1

    I tried that but it gave the answer 'FALSE'.

    As far as the Column C goes, it was a means to an end.  I can dump it.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2013-07-19T04:12:35+00:00

    You can also, starting in 2010, use "Show as % running total" with a pivot table.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2013-07-19T02:49:31+00:00

    The formula in D3 could have been,

    =SUM(B$3:B3)/$B$15

    ... copied down to D14. I'm not sure what you would do with the unnecessary column C.

    Was this answer helpful?

    0 comments