PDA

View Full Version : Generating a Pareto chart based on date



alice123
10-18-2017, 08:47 AM
I would like to make a Pareto chart based on 2 columns of Data. 1 is a string of letters and numbers let's call it column A, the other is a date (formatted as dd-mmm-yy e.g. 18-Oct-2017).


There is no option to create a Pareto chart in Excel 2010 (the version I'm using), and I was wondering if it's possible to create a Pareto chart with those data.


Basically I want it to display, based on year, how many entries there are in Column A. For example, if there are 4 entries in Column A associated with 2014, I want 2014 on the X-axis and the 4 on the Y-axis to show in the chart.


I'm new to vba coding so I would really appreciate any help I can get in this. I have already tried to google it but there isn't anything that could help. If you have sample code that would be really nice.


Thank you!

SamT
10-18-2017, 03:01 PM
About Pareto Charts:
https://en.wikipedia.org/wiki/Pareto_chart
http://asq.org/learn-about-quality/cause-analysis-tools/overview/pareto.html
https://www.isixsigma.com/tools-templates/pareto/pareto-chart-bar-chart-histogram-and-pareto-principle-8020-rule/

offthelip
10-18-2017, 04:28 PM
One way to get a display which is close to a pareto is to use the Stock Chart : Volume, open ,high, low ,close .

then for each row set the open, high, low and close to the same value, which can be the sum of the "volume". This will give you the bars on the chart and the individual indicators but not the line joining the up