1. N

    No data labels on Pareto Line of Pareto Chart

    Excel in office 365 now has a dedicated Pareto chart which is quick and easy to use. However, there is no option to add data labels to the Pareto line to show the percentage values. Am I missing something obvious here?
  2. T

    Getting Run Time Error ( Out of Range ) when trying to change the Title of Pareto Chart

    Hi all, I'm a beginner on VBA, and sorry if my code is not clean. i'm trying to create a Pareto chart on the same worksheet where i already have another column chart. I used the Macro recorder to get the code. The First Chart is working fine. When i try to add the second chart (...
  3. D

    Need help creating 20/80 Pareto Principle with just Formulas

    Hello, While I understand what 20/80 means (20% of Sales, which brings 80% of the business). I've never used this in any of my past works so I have no idea how to do this and what the terms I need. I've been scouring the web and can't find an answer for this - everyone is talking about pivot...
  4. J

    how to add percentage to your line on a pareto tabel EXCEL 2016

    Hey everyone i need your help how to add percentage to your line on a pareto tabel EXCEL 2016
  5. D

    How to show values in data labels of Excel Pareto Chart when chart is based on percentages

    Hello, I am developing a Pareto Chart for my client in Excel 2010. They currently have a chart that shows the percentage of each category on the primary Y-axis. Then, the secondary Y-axis is used for the cumulative percentage, up to 100%. So far, this is a normal and easy to create...
  6. G

    Pivot Table - Pareto Principle? Show top 80%?

    How do I create a pivot table that only shows the details for the top 80% of the subtotals and then shows the remaining 20% all lumped together in a "miscellaneous" category?
  7. L

    Pareto Chart - Need Help on Starting Point...

    Problem: I want my cumulative line in the pareto charts that I create to start in the lower left corner and continue to the upper right. Background: I frequently make pareto charts for evaluation of our products that have problems. When I create a pareto chart manually in Excel 2007, the...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...