+ Reply to Thread
Results 1 to 4 of 4

Pareto Chart /Formula uploaded file

  1. 07-05-2014, 10:28 AM #1
    adhca
    adhca is offline
    Registered User
    Join Date
    06-30-2011
    Location
    North Carolina
    MS-Off Ver
    Excel 2007
    Posts
    21

    Pareto Chart /Formula uploaded file

    HI

    I am trying to calculate cumulative % using the frequency and total amount 955, I don't know how to write this formula in excel , please assist so I can develop a pareto chart using a clustered column. I am getting an error in cumulative frequency, I am adding for example: cumulative Frequency 296+257 = 553 and so on..., then I have to get my cumulative percentage along with the grand total. I have attached file below
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-05-2014, 10:37 AM #2
    Ron Coderre
    Ron Coderre is offline
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Pareto Chart /Formula uploaded file

    Pareto Charts offer unusual complications.
    See if the attached file helps.
    Attached Files Attached Files
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules
    Reply With QuoteRegister To Reply
  3. 07-05-2014, 11:33 AM #3
    GIS2013
    GIS2013 is offline
    Forum Contributor
    Join Date
    12-30-2012
    Location
    Israel
    MS-Off Ver
    2007, 2016
    Posts
    642

    Re: Pareto Chart /Formula uploaded file

    Hi adhca, see if the attached may help you..
    Attached Files Attached Files
    Please * if you like the answer
    Reply With QuoteRegister To Reply
  4. 07-08-2014, 11:54 AM #4
    ExcelIsEasy
    ExcelIsEasy is offline
    Registered User
    Join Date
    01-21-2012
    Location
    New York
    MS-Off Ver
    Excel 2010
    Posts
    41

    Re: Pareto Chart /Formula uploaded file

    Aren't above attachments good enough? Maybe you will like this Pareto Chart Template ? I hope it helps. If not don't be shy and post your question
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Pareto Chart/Formula
    By adhca in forum Excel General
    Replies: 11
    Last Post: 07-05-2014, 03:39 PM
  2. Update chart souce data - excel file was uploaded
    By Snoopy2003 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-01-2010, 05:01 PM
  3. Pareto chart
    By arnab0711 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-06-2010, 02:08 PM
  4. Pareto Chart, set line chart origin at zero
    By ExcelFed in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-03-2008, 05:08 PM
  5. [SOLVED] How do I set up a Pareto chart in Excel?
    By Paul in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-06-2005, 06:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1